10 2011 档案

摘要: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(' 阅读全文
posted @ 2011-10-12 14:35 jex 阅读(391) 评论(0) 推荐(0)