C:\Documents and Settings\Paul Yi>sqlplus "/as sysdba"

SQL*Plus: Release 9.2.0.4.0 - Production on Thu Feb 21 10:53:55 2008

Connected to:
Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.4.0 - Production

SQL> select * from test;

no rows selected

SQL> insert into test values(100);

1 row created.

SQL> commit;

Commit complete.

SQL> select dbms_flashback.get_system_change_number SCN from dual;

SCN
----------
3251266

SQL> update test set id=200;

1 row updated.

SQL> update test set id=300;

1 row updated.

SQL> update test set id=400;

1 row updated.

SQL> update test set id=500;

1 row updated.

SQL> commit;

Commit complete.

SQL> select id from test;

ID
----------
500

SQL> select dbms_flashback.get_system_change_number SCN from dual;

SCN
----------
3251287

--回到原来状态

SQL> select id from test as of scn 3251266
2 ;

ID
----------
100

SQL>

ITPub博客

oracle 闪回查询

最新文章