user_recyclebin and recyclebin in 10g & 11g


SQL> select * from user_recyclebin;

no rows selected

SQL> desc user_recyclebin;
Name Null? Type
—————————————– ——– —————————-
OBJECT_NAME NOT NULL VARCHAR2(30)
ORIGINAL_NAME VARCHAR2(32)
OPERATION VARCHAR2(9)
TYPE VARCHAR2(25)
TS_NAME VARCHAR2(30)
CREATETIME VARCHAR2(19)
DROPTIME VARCHAR2(19)
DROPSCN NUMBER
PARTITION_NAME VARCHAR2(32)
CAN_UNDROP VARCHAR2(3)
CAN_PURGE VARCHAR2(3)
RELATED NOT NULL NUMBER
BASE_OBJECT NOT NULL NUMBER
PURGE_OBJECT NOT NULL NUMBER
SPACE NUMBER

SQL> show parameter recyclebin

NAME TYPE VALUE
———————————— ———– ——————————
recyclebin string on
SQL>

Leave a comment