ORACLE 10g 中恢復已刪除的表

-- 筆記中部分內容SQL> create table tt2 as select * from employee;Table created.SQL> drop table tt2;Table dropped.SQL> select * from tt2; select * from tt2 *ERROR at line 1:ORA-00942: table or view does not existSQL> flashback table tt2 to before drop;Flashback complete.SQL> select count(1) from tt2; COUNT(1)---------- 32如果在表刪除後,又新建了這個表,恢復時可以重新命名,如下:SQL> drop table tt2;Table dropped.SQL> flashback table tt2 to before drop 2 rename to tt2_old;Flashback complete.SQL> select c...

Link URL: http://wmlm.itpub.net/post/12871/457836