ADM_RECYCLEBIN

DROP: The object has been dropped (the object is no longer needed).
TRUNCATE: The object is truncated.

ADM_RECYCLEBIN displays information about all recycle bins. By default, only the system administrator can access this view. Common users can access the view only after being authorized. This view exists in both PG_CATALOG and SYS schema.

**Table 1** ADM_RECYCLEBIN columns
Name	Type	Description
owner	character varying(128)	Original owner name of the object.
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 has been dropped (the object is no longer needed). 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)	Specifies whether to flash back an object.
can_purge	character varying(3)	Specifies whether to purge an 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.