drop table tb_xxxxx;误操作之后
1、查看回收站表
select object_name,original_name,partition_name,type,ts_name,createtime,droptime from recyclebin;
2、恢复删除表
flashback table tb_xxxxx to before drop;
drop table tb_xxxxx;误操作之后
1、查看回收站表
select object_name,original_name,partition_name,type,ts_name,createtime,droptime from recyclebin;
2、恢复删除表
flashback table tb_xxxxx to before drop;