一、在数据库回收站中查看drop掉的表信息,有信息则可以恢复
select * from user_recyclebin order by droptime desc;
select * from reccylebin order by droptime desc;
二、闪回删除的表
flashback table mzl to before drop;在数据的回收站中已经没有此表。
一、在数据库回收站中查看drop掉的表信息,有信息则可以恢复
select * from user_recyclebin order by droptime desc;
select * from reccylebin order by droptime desc;
二、闪回删除的表
flashback table mzl to before drop;在数据的回收站中已经没有此表。