--去回收站查找DROP表(查不到的话,就无法用下面方法恢复了) 已经被清掉了
SELECT OBJECT_NAME,ORIGINAL_NAME,PARTITION_NAME,TYPE,TS_NAME,CREATETIME,DROPTIME FROM RECYCLEBIN;
--恢复
FLASHBACK TABLE "BIN$A+YFUPNSSmy6laPRNGPaVg==$0" TO BEFORE DROP;
--去回收站查找DROP表(查不到的话,就无法用下面方法恢复了) 已经被清掉了
SELECT OBJECT_NAME,ORIGINAL_NAME,PARTITION_NAME,TYPE,TS_NAME,CREATETIME,DROPTIME FROM RECYCLEBIN;
--恢复
FLASHBACK TABLE "BIN$A+YFUPNSSmy6laPRNGPaVg==$0" TO BEFORE DROP;