度量快速开发平台-专业、快速的软件定制快开平台
标题:
恢复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://p.delit.cn/)
Powered by Discuz! X3.2