MY_RECYCLEBIN
MY_RECYCLEBIN displays information about the recycle bin owned by the current user. This view exists in the PG_CATALOG and SYS schemas and all users can access this view.
| 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(18) | Operation performed on an object. The options are as follows:
|
| type | character varying(25) | Object class. |
| 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 | oid | ID of a base object. |
| purge_object | oid | ID of the purged object. |
| space | numeric | Number of blocks used by an object. |
