Skip Headers
Oracle® Database Reference
11g Release 2 (11.2)

Part Number E10820-02
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
View PDF

DBA_RECYCLEBIN

DBA_RECYCLEBIN displays information about all recycle bins in the database.

Related View

USER_RECYCLEBIN displays information about the recycle bin owned by the current user. This view does not display the OWNER column.

Column Datatype NULL Description
OWNER VARCHAR2(30) NOT NULL Name of the original owner of the object
OBJECT_NAME VARCHAR2(30) NOT NULL New name of the object
ORIGINAL_NAME VARCHAR2(32)   Original name of the object
OPERATION VARCHAR2(9)   Operation carried out on the object:
  • DROP - Object was dropped

  • TRUNCATE - Object was truncated

    Note: The Oracle Database currently only supports recovering dropped objects from the recycle bin. The truncated objects cannot be recovered.

TYPE VARCHAR2(25)   Type of the object:
  • TABLE

  • NORMAL INDEX

  • BITMAP INDEX

  • NESTED TABLE

  • LOB

  • LOB INDEX

  • DOMAIN INDEX

  • IOT TOP INDEX

  • IOT OVERFLOW SEGMENT

  • IOT MAPPING TABLE

  • TRIGGER

  • CONSTRAINT

  • Table Partition

  • Table Composite Partition

  • Index Partition

  • Index Composite Partition

  • LOB Partition

  • LOB Composite Partition

TS_NAME VARCHAR2(30)   Name of the tablespace to which the object belongs
CREATETIME VARCHAR2(19)   Timestamp for the creation of the object
DROPTIME VARCHAR2(19)   Timestamp for the dropping of the object
DROPSCN NUMBER   System change number (SCN) of the transaction which moved the object to the recycle bin
PARTITION_NAME VARCHAR2(32)   Name of the partition which was dropped
CAN_UNDROP VARCHAR2(3)   Indicates whether the object can be undropped (YES) or not (NO)
CAN_PURGE VARCHAR2(3)   Indicates whether the object can be purged (YES) or not (NO)
RELATED NUMBER NOT NULL Object number of the parent object
BASE_OBJECT NUMBER NOT NULL Object number of the base object
PURGE_OBJECT NUMBER NOT NULL Object number for the object which gets purged
SPACE NUMBER   Number of blocks used by the object