这句是查询Oracle中回收站的数据
select object_name,original_name,partition_name,type,ts_name,createtime,droptime from recyclebin;
恢复:
SQL>flashback table test_drop to before drop;或
SQL>flashback table "BIN$b+XkkO1RS5K10uKo9BfmuA==$0" to before drop;本文共 291 字,大约阅读时间需要 1 分钟。
这句是查询Oracle中回收站的数据
select object_name,original_name,partition_name,type,ts_name,createtime,droptime from recyclebin;
恢复:
SQL>flashback table test_drop to before drop;或
SQL>flashback table "BIN$b+XkkO1RS5K10uKo9BfmuA==$0" to before drop;转载于:https://www.cnblogs.com/zuizui1204/p/10071614.html