DBA Data[Home] [Help] [Dependency Information]

VIEW: SYS.DBA_RECYCLEBIN

Object Details
Object Name: DBA_RECYCLEBIN
Object Type: VIEW
Owner: SYS
Subobject Name:
Status: VALID

Description of the Recyclebin view accessible to the user

[View Source]

Columns
Name Datatype Length Mandatory Comments
OWNER VARCHAR2 (128) Yes Name of the original owner of the object
OBJECT_NAME VARCHAR2 (128) Yes New name of the object
ORIGINAL_NAME VARCHAR2 (128)
Original name of the object
OPERATION VARCHAR2 (9)
Operation carried out on the object
TYPE VARCHAR2 (25)
Type of the object
TS_NAME VARCHAR2 (30)
Tablespace Name to which object belongs
CREATETIME VARCHAR2 (19)
Timestamp for the creating of the object
DROPTIME VARCHAR2 (19)
Timestamp for the dropping of the object
DROPSCN NUMBER

SCN of the transaction which moved object to Recycle Bin
PARTITION_NAME VARCHAR2 (128)
Partition Name which was dropped
CAN_UNDROP VARCHAR2 (3)
User can undrop this object
CAN_PURGE VARCHAR2 (3)
User can purge this object
RELATED NUMBER
Yes Parent objects Obj#
BASE_OBJECT NUMBER
Yes Base objects Obj#
PURGE_OBJECT NUMBER
Yes Obj# for object which gets purged
SPACE NUMBER

Number of blocks used by this object
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT OWNER
,      OBJECT_NAME
,      ORIGINAL_NAME
,      OPERATION
,      TYPE
,      TS_NAME
,      CREATETIME
,      DROPTIME
,      DROPSCN
,      PARTITION_NAME
,      CAN_UNDROP
,      CAN_PURGE
,      RELATED
,      BASE_OBJECT
,      PURGE_OBJECT
,      SPACE
FROM SYS.DBA_RECYCLEBIN;

Dependencies

[top of page]

SYS.DBA_RECYCLEBIN references the following:

SchemaSYS
TableRECYCLEBIN$
TableTS$
TableUSER$
View_CURRENT_EDITION_OBJ
SYS.DBA_RECYCLEBIN is referenced by following:

SchemaPUBLIC
SynonymDBA_RECYCLEBIN