恢复oracle中误删除drop掉的表及数据

1、查看回收站中表
select object_name,original_name,partition_name,type,ts_name,createtime,droptime from recyclebin where original_name like ‘sys_%’;
注：1.可以加入表名（object_name）或时间（droptime）条件
2.可以把表名（object_name）拼成恢复表的 sql 语句，即
select ‘flashback table "’||object_name||’" to before drop;’,original_name,
partition_name,type,ts_name,createtime,droptime from recyclebin
where original_name like ‘sys_%’;

2、恢复表
恢复表结构：flashback table original_name to before drop;
恢复表结构及数据：flashback table object_name to before drop;

关于索引和触发器等相关对象，请参考以下：
https://www.cnblogs.com/xiaoyu1994/p/8304969.html