配置与使用闪回之闪回版本查询

闪回版本查询

SQL> select dbms_flashback.get_system_change_number from dual;

 GET_SYSTEM_CHANGE_NUMBER

------------------------

                 1458276

 SQL> insert into confirm_table select 6,7 from dual;

 1 row inserted

 SQL> select dbms_flashback.get_system_change_number from dual;

 GET_SYSTEM_CHANGE_NUMBER

------------------------

                 1458293

 SQL> insert into confirm_table select 7,7 from dual;

 1 row inserted

 SQL> delete from confirm_table;

 7 rows deleted

 SQL> select dbms_flashback.get_system_change_number from dual;

 GET_SYSTEM_CHANGE_NUMBER

------------------------

                 1458308

 SQL> commit;

 Commit complete

 SQL> select dbms_flashback.get_system_change_number from dual;

 GET_SYSTEM_CHANGE_NUMBER

------------------------

                 1458312

SQL> select yh_id,realorder,versions_startscn,versions_endscn,

versions_operation,versions_xid from confirm_table

versions between scn 1458276 and  1458312;