SQL> select * from test;
ID
--------------------
A
a
SQL> update test set id='b'||rownum;
2 rows updated
SQL> commit;
Commit complete
SQL> select * from test;
ID
--------------------
b1
b2
SQL> select * from test as of timestamp(systimestamp - interval'1'minute);
ID
--------------------
A
a
最初由 zhouwf0726 发布
[B]SQL> select * from test;
ID
--------------------
A
a
SQL> update test set id='b'||rownum;
2 rows updated
SQL> commit;
Commit complete
SQL> select * from test;
ID
--------------------
b1
b2
SQL> select * from test as of timestamp(systimestamp - interval'1'minute);
ID
--------------------
A
a [/B]
这个是flashback的咚咚吧,还没时间研究呢。
还有你可以使用LOGMGR去日志中得到你的操作的UNDO的sql,然后恢复回来,我这么干过几次了