MY_RECYCLEBIN

DROP: The object is deleted (the object is no longer required).
TRUNCATE: The object is truncated.

MY_RECYCLEBIN displays information about the recycle bin owned by the current user. This view exists in the PG_CATALOG and SYS schema and all users can access this view.

**Table 1** MY_RECYCLEBIN columns
Name	Type	Description
object_name	character varying(128)	New name of an object.
original_name	character varying(128)	Original name of an object.
operation	character varying(9)	Operation performed on an object. The options are as follows: DROP: The object is deleted (the object is no longer required). TRUNCATE: The object is truncated.
type	character varying(25)	Object type.
ts_name	character varying(30)	Name of the tablespace to which the object belongs.
createtime	character varying(19)	Timestamp when an object is created.
droptime	character varying(19)	Timestamp when an object is deleted.
dropscn	numeric	System change number (SCN) of the transaction that moves an object to the recycle bin.
partition_name	character varying(128)	Name of a deleted partition.
can_undrop	character varying(3)	Determines whether to flash back an object.
can_purge	character varying(3)	Determines whether to purge the object.
related	numeric	ID of the parent object.
base_object	numeric	ID of a base object.
purge_object	numeric	ID of the purged object.
space	numeric	Number of blocks used by an object.