本文共 4281 字,大约阅读时间需要 14 分钟。
SQL> conn scott/tiger; 已连接。 SQL> create table mytest as select * from dept; 表已创建。 SQL> drop table mytest; 表已删除。 SQL> flashback table mytest to before drop; 闪回完成。 SQL> select * from mytest; DEPTNO DNAME LOC ---------- -------------- ------------- 10 ACCOUNTING NEW YORK 20 RESEARCH DALLAS 30 SALES CHICAGO 40 OPERATIONS BOSTON SQL> drop table mytest; 表已删除。 |
SQL> desc recyclebin; |
SQL> select * from recyclebin; SQL> select object_name,droptime,dropscn,purge_object from recyclebin; OBJECT_NAME DROPTIME DROPSCN PURGE_OBJECT ------------------------------ ------------------- ---------- ------------ BIN$ugr+dcX2R1Kk6imZ2wEQOQ==$0 2007-08-10:21:33:43 5456762 54660 |
SQL> select * from mytest; DEPTNO DNAME LOC ---------- -------------- ------------- 10 ACCOUNTING NEW YORK 20 RESEARCH DALLAS 30 SALES CHICAGO 40 OPERATIONS BOSTON SQL> d rop table mytest purge; 表已删除。 SQL> select object_name,droptime,dropscn,purge_object from recyclebin; OBJECT_NAME DROPTIME DROPSCN PURGE_OBJECT ------------------------------ ------------------- ---------- ------------ |
SQL> select owner,original_name,object_name,ts_name,droptime from dba_recyclebin; OWNER ORIGINAL_NAME OBJECT_NAME TS_NAME ------------------------------ -------------------------------- ------------------------------ ----- SCOTT BONUS BIN$cyqKxbJ9SQWbX52tIgAS9A==$0 USERS SCOTT SALGRADE BIN$myTqyz98SN6Oi6IAmPA4LA==$0 USERS |
SQL> conn scott/tiger; 已连接。 使用SCOTT用户登录后进行查询。 SQL> select * from "BIN$myTqyz98SN6Oi6IAmPA4LA==$0"; GRADE LOSAL HISAL ---------- ---------- ---------- 1 700 1200 2 1201 1400 3 1401 2000 4 2001 3000 5 3001 9999 |
PURGE TABLESPACE users USER scott |
转载地址:http://oavdi.baihongyu.com/