Flashback [Oracle SQL] 使用方法

三種方法
使用SCN
flashback table my_table to scn 699310;
Timestamp
flashback table my_table to timestamp '2008-03-03 10:08:31';
Before drop
flashback table "BIN$ewhgTFxaSyuts++4swyE3Q==$0" to before drop rename to test_objects;

舉例：

--首先使用flashback 恢復已經drop的物件,必須在10g以上的版本
SQL> select * from v$version;

BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod
PL/SQL Release 10.2.0.1.0 - Production
CORE 10.2.0.1.0 Production
TNS for 32-bit Windows: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production

SQL>

SQL> conn gaoyj/gaoyj
已連線。
SQL> conn / as sysdba
已連線。
SQL> conn gaoyj/gaoyj
已連線。

SQL> create table test_objects as select * from all_objects;

表已建立。

SQL> show recyclebin
SQL> show recyclebin;
SQL> drop table test_objects;

表已刪除。

SQL> show recyclebin;
ORIGINAL NAME RECYCLEBIN NAME OBJECT TYPE DROP TIME
---------------- ------------------------------ ------------ -------------------

TEST_OBJECTS BIN$ewhgTFxaSyuts++4swyE3Q==$0 TABLE 2008-03-03:15:19:42

SQL> flashback table "BIN$ewhgTFxaSyuts++4swyE3Q==$0" to before drop rename to t
est_objects;

閃回完成。

SQL> show recyclebin

[@more@]