一.把不小心DROP 的表找回來
SQL> select * from a4;
ID4 XMMC CODE RYID ID2 ID3
---------- ------ ------- ---------- ---------- ----------
2 項目二 XMTWO 1
3 項目三 XMTHREE 1
4 項目一 XMONE 2
SQL> drop table a4;
Table dropped
SQL> select * from a4;
select * from a4
ORA-00942: table or view does not exist
SQL> flashback table a4 to before drop;
Done
SQL> select * from a4;
ID4 XMMC CODE RYID ID2 ID3
---------- ------ ------- ---------- ---------- ----------
2 項目二 XMTWO 1
3 項目三 XMTHREE 1
4 項目一 XMONE 2
二.把DELETE的數據找回來
SQL> select * from a3;
ID4 XMMC CODE RYID ID2 ID3
---------- ------ ------- ---------- ---------- ----------
2 項目二 XMTWO 1
3 項目三 XMTHREE 1
4 項目一 XMONE 2
SQL> delete from a3 where id4=2;
1 row deleted
SQL> commit;
Commit complete
SQL> create table A5 as select * from A3 as of
2 timestamp to_timestamp('2008-1-04 14:23:00','yyyy-mm-dd hh24:mi:ss');
Table created
SQL> select * from a5;
ID4 XMMC CODE RYID ID2 ID3
---------- ------ ------- ---------- ---------- ----------
2 項目二 XMTWO 1
3 項目三 XMTHREE 1
4 項目一 XMONE 2
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/10768286/viewspace-90048/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/10768286/viewspace-90048/