oracle10g回收站recyclebin的基本操作

Oracle10中增加的回收站的功能：

 

1.查看所有与回收站有关的数据对象：

SQL> SELECT T.OWNER,T.OBJECT_NAME,T.OBJECT_TYPE FROM ALL_OBJECTS T WHERE T.OBJECT_NAME LIKE '%RECYCLE%';

 

OWNER                          OBJECT_NAME                    OBJECT_TYPE

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

SYS                            RECYCLEBIN$                    TABLE

SYS                            RECYCLEBIN$_OBJ                INDEX

SYS                            RECYCLEBIN$_TS                 INDEX

SYS                            RECYCLEBIN$_OWNER              INDEX

SYS                            USER_RECYCLEBIN                VIEW

PUBLIC                         USER_RECYCLEBIN                SYNONYM

PUBLIC                         RECYCLEBIN                     SYNONYM

SYS                            DBA_RECYCLEBIN                 VIEW

PUBLIC                         DBA_RECYCLEBIN                 SYNONYM

 

2.查看回收站的东西:

SQL> SHOW RECYCLEBIN

仅仅列出OBJECT_NAME,ORIGINAL_NAME,TYPE,DROPTIME四列。

ORIGINAL NAME    RECYCLEBIN NAME                OBJECT TYPE  DROP TIME

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

A                BIN$R+MY75CQQr+U9AGzM0MJ1Q==$0 TABLE        2009-01-10 :16:02:35

B                BIN$tnTJEnUFSiOVfgMGQJD4NA==$0 TABLE        2009-01-10 :16:02:44

C1               BIN$V+zsHnmGSLe0aaG+UOkWIw==$0 TABLE        2009-01-10 :16:02:54

STUDENT          BIN$zV1QAvZLRF6QUJk1kd9MBg==$0 TABLE        2008-12-28 :17:31:20

T                BIN$0Xc7bFJlQlOhoAan/bp4Fw==$0 TABLE         2008-12-14 :19:42:19

T2               BIN$WuDMiaqgRraE4AwfZyKR1w==$0 TABLE        2009-01-10 :16:03:22

 

3.