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 NUMBERSQL> show parameter recyclebin
NAME TYPE VALUE
———————————— ———– ——————————
recyclebin string on
SQL>
Leave a comment
Comments 0