随手记录的(闪回删除表)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>
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>
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/27795363/viewspace-745524/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/27795363/viewspace-745524/