(转)Oracle恢復意外刪除的數據

1. flashback table table_test to timestamp to_timestamp('20091103000000','yyyymmddhh24miss');

 2.如果報錯ORA-08189: cannot flashback the table because row movement is not enabled

 3.alter table table_test enable row movement;

 4.OK

posted @ 2009-12-24 12:35  PROS  阅读(160)  评论(0)    收藏  举报