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-2014
Some rights reserved