恢复oracle10g误删除的表

最新推荐文章于 2022-06-09 15:42:47 发布

qq_22472921

最新推荐文章于 2022-06-09 15:42:47 发布

阅读量165

点赞数

分类专栏： Oracle相关

Oracle相关专栏收录该内容

19 篇文章 0 订阅

订阅专栏

查看回收站中的表

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;