度量快速开发平台-专业、快速的软件定制快开平台

标题: 恢复oracle10g误删除的表 [打印本页]

作者: caixuqad 时间: 2020-5-19 17:45
标题: 恢复oracle10g误删除的表
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;

作者: caixuqad 时间: 2020-5-19 17:46

作者: fteair 时间: 2020-5-20 15:06

作者: 张兴康 时间: 2020-5-21 14:01

作者: caixuqad 时间: 2020-5-21 19:32

作者: caixuqad 时间: 2020-5-24 00:04

欢迎光临度量快速开发平台-专业、快速的软件定制快开平台 (http://bbs.delit.cn/)