DBA Data[Home] [Help]

VIEW: SYS.CDB_RECYCLEBIN

Source

View Text - Preformatted

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 CONTAINERS("SYS"."DBA_RECYCLEBIN")
View Text - HTML Formatted

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 CONTAINERS("SYS"."DBA_RECYCLEBIN")