回收站打开，ｄｒｏｐ ｔａｂｌｅ…

SQL> flashback table test0407 to before drop;

flashback table test0407 to before drop

*

ERROR at line 1:

ORA-38305: object not in RECYCLE BIN

SQL> 

SQL> create table abc0407 (id number); 

Table created.

SQL>   insert into abc0407 values (10);

1 row created.

SQL> commit;

Commit complete.

SQL> select owner,object_name,droptime from dba_recyclebin;

select owner,object_name,droptime from dba_recyclebin

                                        *

ERROR at line 1:

ORA-00942: table or view does not exist

SQL> select object_name,droptime from user_recyclebin;

no rows selected

SQL> drop table abc0407;

Table dropped.

SQL> /

drop table abc0407

            *

ERROR at line 1:

ORA-00942: table or view does not exist

SQL> select object_name,droptime from user_recyclebin;

no rows selected

SQL> show parameter recy

NAME                                 TYPE         VALUE

------------------------------------ ----------- ------------------------------

buffer_pool_recycle                   string

db_recycle_cache_size                 big integer 0

recyclebin                           string       on

SQL> 

怀疑是drop system表空间的对象导致的

SQL*Plus: Release 11.1.0.7.0 - Production on Fri Apr 7 17:08:26 2017

Copyright (c) 1982, 2008, Oracle.   All rights reserved.

Connected to:

Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> create table test170407 (id number);

Table created.

SQL> insert into test170407 values (10);

1 row created.

SQL> commit;

Commit complete.

SQL>   select object_name,droptime from user_recyclebin;

no rows selected

SQL> drop table test170407;

Table dropped.

SQL> /

drop table test170407

            *

ERROR at line 1:

ORA-00942: table or view does not exist

SQL>   select object_name,droptime from user_recyclebin;

OBJECT_NAME                     DROPTIME

------------------------------ -------------------

BIN$TJEAbSK3uQbgUAAKCAJ0hA==$0 2017-04-07:17:10:49

SQL> 

初步认为， Flashback Drop 用于非系统表空间和本地管理的表空间， 也就是说建在系统表空间的表是不进回收站的。后面看看是否有其他原因