1.确保test表不在system表空间内，否则无法闪回，测试如下：http://www.cndba.cn/hbhe0316/article/107864

SQL> create table test(id int) tablespace users;

Table created.

SQL> drop table test;

Table dropped.

SQL> show recyclebin;
ORIGINAL NAME    RECYCLEBIN NAME                OBJECT TYPE  DROP TIME
---------------- ------------------------------ ------------ -------------------
TEST             BIN$2cqHYtypBhvgU7w4qMCSog==$0 TABLE        2022-03-09:22:01:06
SQL> flashback table test to before drop;

Flashback complete.

SQL> select count(1) from test;

  COUNT(1)
----------
         0

版权声明：本文为博主原创文章，未经博主允许不得转载。

oracle