闪回查询(找出undo sql方法)

最新推荐文章于 2024-12-06 17:01:20 发布

duqiangatom

最新推荐文章于 2024-12-06 17:01:20 发布

阅读量616

点赞数

分类专栏： ORA-DailySQL

本文链接：https://blog.youkuaiyun.com/duqiangatom/article/details/8308976

版权

ORA-DailySQL 专栏收录该内容

16 篇文章

订阅专栏

 SELECT versions_xid,versions_operation, versions_starttime,versions_endtime,VERSIONS_STARTSCN,VERSIONS_ENDSCN
  FROM site_daily_report versions BETWEEN TIMESTAMP minvalue AND maxvalue
 WHERE report_date = trunc(SYSDATE - 14);

 SELECT * FROM flashback_transaction_query t WHERE t.xid=hextoraw('5C00040077070000');

 SELECT DBMS_FLASHBACK.get_system_change_number() FROM DUAL;

 SELECT scn_to_timestamp(DBMS_FLASHBACK.get_system_change_number()) FROM  dual;

 SELECT timestamp_to_scn(Systimestamp) FROM dual;