DBA_RECYCLEBIN

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


© Copyright SS64.com 1999-2016
Some rights reserved