不小心将表删掉了
SQL> Select object_name,original_name,partition_name,type,ts_name, createtime,droptime from recyclebin;
OBJECT_NAME ORIGINAL_NAME PARTITION_NAME TYPE TS_NAME CREATETIME DROPTIME
------------------------------ -------------------------------- -------------------------------- ------------------------- ------------------------------ ------------------- -------------------
BIN$euBA/ylDTFuhunRLSo6/tA==$0 TABLE1 TABLE USERS 2011-12-22:11:43:49 2011-12-23:16:29:41
BIN$INJOfJxsSLOwET7WAirXhQ==$0 TABLE2 TABLE USERS 2011-12-22:11:48:48 2011-12-23:16:29:41
BIN$bfEnhiJgShqeyOWkm/SjrQ==$0 TABLE3 TABLE USERS 2011-12-22:11:54:00 2011-12-23:16:29:41
BIN$ej7rDttsRcmsl+asTIYytw==$0 TABLE4 TABLE USERS 2011-12-22:13:55:47 2011-12-23:16:29:41
4 rows selected
两种方式恢复TABLE1
1、flashback table TABLE1to before drop;
2、flashback table "BIN$euBA/ylDTFuhunRLSo6/tA==$0" to before drop;