--分享一下 oracle意外删除表,需要恢复的知识点:
--从oracle垃圾回收站中查询删除的表信息
select object_name,
original_name,
partition_name,
type,
ts_name,
createtime,
droptime
from recyclebin
where droptime like '2015-01-23:17:%';
--从oracle垃圾回收站中恢复表
FLASHBACK TABLE table_name TO BEFORE DROP;
--从oracle垃圾回收站中查询删除的表信息
select object_name,
original_name,
partition_name,
type,
ts_name,
createtime,
droptime
from recyclebin
where droptime like '2015-01-23:17:%';
--从oracle垃圾回收站中恢复表
FLASHBACK TABLE table_name TO BEFORE DROP;