ORACLE 闪回删除的表/数据，闪回更新数据

1.闪回删除的表/数据

drop from tb_test;

SELECT * FROM user_recyclebin WHERE original_name=‘drop_test’;

flashback table tb_test to before drop;

 

2.闪回更新数据

update tb_test set name= 'xxxxxx' where name='yyyy';

alter table tb_test enable row movement;

flashback table tb_test to timestamp to_timestamp('2011-10-12 11:32:00','yyyy-mm-dd hh24:mi:ss');

转载于:https://www.cnblogs.com/Csharpblogs/archive/2011/10/12/2208615.html