Oracle 11g闪回flashback(四)

SQL> show user;
User is "SYS"

SQL>?

?

oracle10g的闪回删除：
Oracle10g的闪回删除：可以恢复一个被drop的对象，因

为进行drop时，Oracle先把它放到回收站中。（回收站和操作系统的回收站很相似）

? ? 回收站内的信息：show recyclebin

? ? 闪回删除：flashback table to before drop;

? ? 彻底删除：drop table ? purge;

? ? 清空回收站: purge recyclebin;

? ?

Connected to Oracle Database 11g Enterprise Edition Release 11.2.0.1.0
Connected as hr@JIAGULUN

SQL> purge recyclebin;
Done

SQL> select * from tab;
TNAME? ? ? ? ? ? ? ? ? ? TABTYPE? CLUSTERID
------------------------------ ------- ----------
ADDRESS? ? ? ? ? ? ? ? TABLE

SQL> select * from address;
? ? ? ? ID NAME
----------- --------------------
? ? ? ? ? 1 jiangxi
? ? ? ? ? 2 hunan

SQL> show recyclebin;
SQL> select * from user_recyclebin;--回收站并没有任何垃圾
OBJECT_NAME? ? ? ? ORIGINAL_NAME? ? ? ? OPERATION TYPE? ? ? ? ? ? ? ? ? TS_NAME? ? ? ? ? ? ? ? CREATETIME DROPTIME? ? ? DROPSCN PARTITION_NAME? ? ? CAN_UNDROP CAN_PURGE? ? RELATED BASE_OBJECT PURGE_OBJECT? ? ? SPACE
------------------------------ -------------------------------- --------- ------------------------- ------------------------------ ------------------- ------------------- ---------- -------------------------------- ---------- --------- ---------- ----------- ------------ ----------

SQL> drop table address;--删除表
Table dropped

SQL> show recyclebin;
SQL> select * from user_recyclebin;--会发现回收站中出现了——表，索引垃圾
OBJECT_NAME? ? ? ? ORIGINAL_NAME? ? ? ? OPERATION TYPE? ? ? ? ? ? ? ? ? TS_NAME? ? ? ? ? ? ? ? CREATETIME DROPTIME? ? ? DROPSCN PARTITION_NAME? ? ? CAN_UNDROP CAN_PURGE? ? RELATED BASE_OBJECT PURGE_OBJECT? ? ? SPACE
------------------------------ -------------------------------- --------- ------------------------- ------------------------------ ------------------- ------------------- ---------- -------------------------------- ---------- --------- ---------- ----------- ------------ ----------
BIN$DXVcPQqfU6HgUKjAA1tAfw==$0 ADDRESS? ? ? ? ? ? ? ? ? DROP? TABLE? ? ? ? ? ? ? ? USERS? ? ? ? ? ? ? ? ? ? 2015-01-22:06:10:58 2015-01-24:22:49:08? ? 3145534? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? YES? ? YES? ? ? ? 77236? ? ? 77236? ? ? ? 77236? ? ? ? ? 8
BIN$DXVcPQqeU6HgUKjAA1tAfw==$0 PK_ADDRESS? ? ? ? ? ? DROP? INDEX? ? ? ? ? ? ? ? USERS? ? ? ? ? ? ? ? ? ? 2015-01-22:06:10:58 2015-01-24:22:49:08? ? 3145530? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? NO? ? ? YES? ? ? ? 77236? ? ? 77236? ? ? ? 77239? ? ? ? ? 8
BIN$DXVcPQqdU6HgUKjAA1tAfw==$0 INDEX_ADDRESS_NAME DROP? INDEX? ? ? ? ? ? ? ? USERS? ? ? ? ? ? ? ? ? ? 2015-01-22:06:10:58 2015-01-24:22:49:08? ? 3145525? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? NO? ? ? YES? ? ? ? 77236? ? ? 77236? ? ? ? 77240? ? ? ? ? 8

SQL> select * from tab;--刚刚存在address表不见了，但是多了一张下面的表
TNAME? ? ? ? ? ? ? ? ? ? TABTYPE? CLUSTERID
------------------------------ ------- ----------
BIN$DXVcPQqfU6HgUKjAA1tAfw==$0 TABLE

SQL> flashback table student? to before drop;
flashback table student? to before drop
ORA-38305: 对象不在回收站中

SQL> flashback table address? to before drop;--对回收站的表进行闪回
Done

SQL> select * from user_recyclebin;--回收站中的表被闪回了
OBJECT_NAME? ? ? ? ORIGINAL_NAME? ? ? ? OPERATION TYPE? ? ? ? ? ? ? ? ? TS_NAME? ? ? ? ? ? ? ? CREATETIME DROPTIME? ? ? DROPSCN PARTITION_NAME? ? ? CAN_UNDROP CAN_PURGE? ? RELATED BASE_OBJECT PURGE_OBJECT? ? ? SPACE
------------------------------ -------------------------------- --------- ------------------------- ------------------------------ ------------------- ------------------- ---------- -------------------------------- ---------- --------- ---------- ----------- ------------ ----------

SQL> select * from tab;--表被闪回了
TNAME? ? ? ? ?