查询删除的数据:
select object_name,original_name,partition_name,type,ts_name,createtime,droptime from recyclebin;
根据object_name恢复数据:
flashback table “object_name” to before drop;
查询删除的数据:
select object_name,original_name,partition_name,type,ts_name,createtime,droptime from recyclebin;
根据object_name恢复数据:
flashback table “object_name” to before drop;