eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: SYS.USER_RECYCLEBIN

Object Details

Object Name:	USER_RECYCLEBIN
Object Type:	VIEW
Owner:	SYS
Subobject Name:
Status:	VALID

User view of his recyclebin

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
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 undrop 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 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.USER_RECYCLEBIN;

Dependencies

[top of page]

SYS.USER_RECYCLEBIN references the following:

SYS: RECYCLEBIN$; TS$; _CURRENT_EDITION_OBJ

SYS.USER_RECYCLEBIN is referenced by following:

PUBLIC: RECYCLEBIN; USER_RECYCLEBIN