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

VIEW: SYS.CDB_RECYCLEBIN

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

Description of the Recyclebin view accessible to the user in all containers

[View Source]

Columns
Name Datatype Length Mandatory Comments
OWNER VARCHAR2 (30) Yes Name of the original owner of the object
OBJECT_NAME VARCHAR2 (30) 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
CON_ID NUMBER

container id
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
,      CON_ID
FROM SYS.CDB_RECYCLEBIN;

Dependencies

[top of page]

SYS.CDB_RECYCLEBIN does not reference any database object

SYS.CDB_RECYCLEBIN is referenced by following:

SchemaPUBLIC
SynonymCDB_RECYCLEBIN