VIEW: SYS.DBA_RECYCLEBIN

Source

View Text - Preformatted

select u.name, o.name, r.original_name,
       decode(r.operation, 0, 'DROP', 1, 'TRUNCATE', 'UNDEFINED'),
       decode(r.type#, 1, 'TABLE', 2, 'INDEX', 3, 'INDEX',
                       4, 'NESTED TABLE', 5, 'LOB', 6, 'LOB INDEX',
                       7, 'DOMAIN INDEX', 8, 'IOT TOP INDEX',
                       9, 'IOT OVERFLOW SEGMENT', 10, 'IOT MAPPING TABLE',
                       11, 'TRIGGER', 12, 'CONSTRAINT', 13, 'Table Partition',
                       14, 'Table Composite Partition', 15, 'Index Partition',
                       16, 'Index Composite Partition', 17, 'LOB Partition',
                       18, 'LOB Composite Partition',
                       'UNDEFINED'),
       t.name,
       to_char(o.ctime, 'YYYY-MM-DD:HH24:MI:SS'),
       to_char(r.droptime, 'YYYY-MM-DD:HH24:MI:SS'),
       r.dropscn, r.partition_name,
       decode(bitand(r.flags, 4), 0, 'NO', 4, 'YES', 'NO'),
       decode(bitand(r.flags, 2), 0, 'NO', 2, 'YES', 'NO'),
       r.related, r.bo, r.purgeobj, r.space
from sys."_CURRENT_EDITION_OBJ" o, sys.recyclebin$ r, sys.user$ u, sys.ts$ t
where o.obj# = r.obj#
  and r.owner# = u.user#
  and r.ts# = t.ts#(+)

View Text - HTML Formatted

SELECT U.NAME
, O.NAME
, R.ORIGINAL_NAME
, DECODE(R.OPERATION
, 0
, 'DROP'
, 1
, 'TRUNCATE'
, 'UNDEFINED')
, DECODE(R.TYPE#
, 1
, 'TABLE'
, 2
, 'INDEX'
, 3
, 'INDEX'
, 4
, 'NESTED TABLE'
, 5
, 'LOB'
, 6
, 'LOB INDEX'
, 7
, 'DOMAIN INDEX'
, 8
, 'IOT TOP INDEX'
, 9
, 'IOT OVERFLOW SEGMENT'
, 10
, 'IOT MAPPING TABLE'
, 11
, 'TRIGGER'
, 12
, 'CONSTRAINT'
, 13
, 'TABLE PARTITION'
, 14
, 'TABLE COMPOSITE PARTITION'
, 15
, 'INDEX PARTITION'
, 16
, 'INDEX COMPOSITE PARTITION'
, 17
, 'LOB PARTITION'
, 18
, 'LOB COMPOSITE PARTITION'
, 'UNDEFINED')
, T.NAME
, TO_CHAR(O.CTIME
, 'YYYY-MM-DD:HH24:MI:SS')
, TO_CHAR(R.DROPTIME
, 'YYYY-MM-DD:HH24:MI:SS')
, R.DROPSCN
, R.PARTITION_NAME
, DECODE(BITAND(R.FLAGS
, 4)
, 0
, 'NO'
, 4
, 'YES'
, 'NO')
, DECODE(BITAND(R.FLAGS
, 2)
, 0
, 'NO'
, 2
, 'YES'
, 'NO')
, R.RELATED
, R.BO
, R.PURGEOBJ
, R.SPACE FROM SYS."_CURRENT_EDITION_OBJ" O
, SYS.RECYCLEBIN$ R
, SYS.USER$ U
, SYS.TS$ T WHERE O.OBJ# = R.OBJ#
AND R.OWNER# = U.USER#
AND R.TS# = T.TS#(+)