SQL> conn / as sysdba
Connected.
SQL> create table test (T varchar2(20));
Table created.
SQL> DROP TABLE TEST;
Table dropped.
SQL> FLASHBACK TABLE TEST TO BEFORE DROP;
FLASHBACK TABLE TEST TO BEFORE DROP
*
ERROR at line 1:
ORA-38305: object not in RECYCLE BIN
SQL> show parameter recycle
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
buffer_pool_recycle string
db_recycle_cache_size big integer 0
recyclebin string on
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/31448824/viewspace-2137531/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/31448824/viewspace-2137531/