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

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 (idnumber); 

Table created.

SQL>  insert into abc0407 values(10);

1 row created.

SQL> commit;

Commit complete.

SQL> select owner,object_name,droptime fromdba_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 fromuser_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 fromuser_recyclebin;

no rows selected

SQL> show parameter recy

NAME                            TYPE       VALUE

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

buffer_pool_recycle               string

db_recycle_cache_size              big integer0

recyclebin                       string     on

SQL> 

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

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

Copyright (c) 1982, 2008, Oracle.  All rightsreserved.

Connected to:

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

With the Partitioning, OLAP, Data Mining and Real ApplicationTesting 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 fromuser_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 fromuser_recyclebin;

OBJECT_NAME                 DROPTIME

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

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

SQL> 

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