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:
|
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 |