恢复oracle10g误删除的表

caixuqad

查看回收站中的表

    select object_name,original_name,createtime,droptime from recyclebin where type='TABLE';

    OBJECT_NAME                                       ORIGINAL_NAME                    CREATETIME                       DROPTIME
------------------------------                             -------------------------------- -------------------                      -------------------
BIN$N21ZpomQThW2uZe5L0SCiA==$0     BPM_WF_WORKITEM               2009-10-30:16:39:09    2009-10-31:09:23:53
BIN$PCO4ASB5Tum6eyfixfucTQ==$0         BPM_WF_USERAGENT1            2009-09-04:08:49:26    2009-10-31:09:23:45
BIN$SWNJzCSbQMawSCESRlnrag==$0     BPM_WF_TASKINSTANCE         2009-10-30:16:39:08    2009-10-31:09:23:31
BIN$KxBQOxXpRmGpM/JNAl2d4w==$0    BPM_WF_PROCESSMODEL        2009-10-30:16:39:04    2009-10-31:09:23:14
BIN$kI2bBfJDRVWnOm05RIslNw==$0       BPM_WF_PROCESSINSTANCE   2009-10-30:16:39:06    2009-10-31:09:23:00
BIN$+nzIoB6GRA2+L+KGYd4PmA==$0     BPM_WF_PROCESSDEF              2009-10-30:16:39:03    2009-10-31:09:22:44
BIN$0S6J8E6AT9eUxWIQN9kDKA==$0     BPM_WF_INITIATEITEM             2009-10-30:16:39:05    2009-10-31:09:22:13
BIN$WQWGimVXSgGJqqgW54hwvQ==$0   BPM_ORG_USER1                    2009-10-13:15:25:31    2009-10-31:09:22:00
BIN$FbO7phvmTy6imYOuUrNrvA==$0       BPM_ORG_DEPARTMENTS1     2009-10-13:15:25:31    2009-10-31:09:20:47
BIN$WGZMaJZBRfezCbUEHzneEQ==$0     BPM_MSG_MYFRIENDS             2009-10-30:16:34:14    2009-10-30:16:39:11

OBJECT_NAME 是在回收站中表的新标识，ORIGINAL_NAME是删除前的表名，

根据DROPTIME找到误删的表

FLASHBACK TABLE "BIN$N21ZpomQThW2uZe5L0SCiA==$0" TO BEFORE DROP RENAME TO BPM_WF_WORKITEM1;

fteair

张兴康

学习了

caixuqad

caixuqad