ITPub博客

　　本篇主要練習利用打開時的備貨進行不完全恢复。[@more@]-- 備份前數据 SYS@HUIYI>select * from t; COL ------------------ 09-Mar-07 10:42:05 -- 備份 SYS@HUIYI>@open_backup; -- 備份後的數据 SYS@HUIYI>insert into t values(sysdate); 1 row created. SYS@HUIYI>commit; Commit complete. SYS@HUIYI>select * from t; COL ------------------ 09-Mar-07 10:42:05 09-Mar-07 16:22:55 -- 刪除 還原 SYS@HUIYI>drop tablespace tbs01 including contents an