- 使用以下语句查询删除的表,根据节点恢复表
select object_name,original_name,partition_name,type,ts_name,createtime,droptime from recyclebin where type='TABLE' order by droptime desc;
- 根据查询object_name恢复表,如果该表名已经存在,需要删除对应的表才能够恢复表
flashback table "BIN$uXeD0+B1K1LgVfz8/vRAFw==$0" to before drop;