flashback_transaction_query

flashback_transaction_query

- SELECT ANY TRANSACTION 권한 필요

- 시간확인(초)

select * From v$parameter
where name = 'db_flashback_retention_target'

 

select * From SCOTT.EMP versions between scn minvalue and maxvalue;

 

select * from SCOTT.EMP as of timestamp to_timestamp('2013-11-07 15:31', 'yyyy-mm-dd hh24:mi')

 

select * from SCOTT.EMP as of timestamp sysdate - ((1 / 1440) * 30 /*분전*/)

 

- undo sql

select * from flashback_transaction_query
where table_owner = 'SCOTT'
and table_name = 'EMP'
and commit_timestamp between to_timestamp('2013-11-07 15:00', 'yyyy-mm-dd hh24:mi') and to_timestamp('2013-11-07 15:40', 'yyyy-mm-dd hh24:mi')
order by start_timestamp desc;

 

select *
  from sys.source$ as of timestamp sysdate - ((1 / 1440) * 20 /*분전*/)
 where obj# in (select object_id
                  from dba_objects
                 where object_name = upper('sp_procedure'))
 order by 1, 2