Information about all recycle bins in the database.
Columns
___________________________
OWNER Name of the original owner of the object
OBJECT_NAME New name of the object
ORIGINAL_NAME Original name of the object
OPERATION Operation carried out on the object (Drop/Truncate)
TYPE Type of the object (Table/index/Partition etc)
TS_NAME Name of the tablespace to which the object belongs
CREATETIME Timestamp for the creation of the object
DROPTIME Timestamp for the dropping of the object
DROPSCN System change number (SCN) of the transaction which moved the object to the recycle bin
PARTITION_NAME Name of the partition which was dropped
CAN_UNDROP Indicates whether the object can be undropped (YES) or not (NO)
CAN_PURGE Indicates whether the object can be purged (YES) or not (NO)
RELATED Object number of the parent object
BASE_OBJECT Object number of the base object
PURGE_OBJECT Object number for the object which gets purged
SPACE Number of blocks used by the object
Related:
USER_RECYCLEBIN