1. 查看删除的对象的信息
select object_name,original_name,partition_name,type,ts_name,createtime,droptime from recyclebin;
2. 恢复被误删的表
flashback table 表名 to before drop;
1. 查看删除的对象的信息
select object_name,original_name,partition_name,type,ts_name,createtime,droptime from recyclebin;
2. 恢复被误删的表
flashback table 表名 to before drop;