随手记录的（闪回删除表）flashback table  过程：


SYSTEM@orcl> conn / as sysdba
Connected.
SYS@orcl> sho parameter version
SYS@orcl> select * from v$version;

BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
PL/SQL Release 11.2.0.1.0 - Production
CORE    11.2.0.1.0      Production
TNS for Linux: Version 11.2.0.1.0 - Production
NLSRTL Version 11.2.0.1.0 - Production

5 rows selected.

SYS@orcl>







SYS@orcl> CREATE TABLE MEMP AS SELECT * FROM SCOTT.EMP;

Table created.

SYS@orcl> COMMIT;

Commit complete.

SYS@orcl> select object_name,original_name from recyclebin;

no rows selected

SYS@orcl>
SYS@orcl> DROP TABLE MEMP;

Table dropped.

SYS@orcl> FLASHBACK TABLE MEMP TO BEFORE DROP;
FLASHBACK TABLE MEMP TO BEFORE DROP
*
ERROR at line 1:
ORA-38305: object not in RECYCLE BIN


SYS@orcl> CONN system/oracle
Connected.
SYSTEM@orcl> CREATE TABLE MEMP AS SELECT * FROM SCOTT.EMP;

Table created.

SYSTEM@orcl> DROP TABLE MEMP;

Table dropped.

SYSTEM@orcl> FLASHBACK TABLE MEMP TO BEFORE DROP;
FLASHBACK TABLE MEMP TO BEFORE DROP
*
ERROR at line 1:
ORA-38305: object not in RECYCLE BIN


SYSTEM@orcl>