VIEW: SYS.DBA_RECOVERABLE_SCRIPT_BLOCKS

Source

View Text - Preformatted

select oid, block_num, forward_block, forward_block_dblink, undo_block,
undo_block_dblink,
decode(status, 1, 'GENERATING',
               2, 'NOT EXECUTED',
               3, 'EXECUTING',
               4, 'EXECUTED',
               5, 'ERROR',
               6, 'PURGED'),
block_comment
from sys.reco_script_block$

View Text - HTML Formatted

SELECT OID
, BLOCK_NUM
, FORWARD_BLOCK
, FORWARD_BLOCK_DBLINK
, UNDO_BLOCK
, UNDO_BLOCK_DBLINK
, DECODE(STATUS
, 1
, 'GENERATING'
, 2
, 'NOT EXECUTED'
, 3
, 'EXECUTING'
, 4
, 'EXECUTED'
, 5
, 'ERROR'
, 6
, 'PURGED')
, BLOCK_COMMENT FROM SYS.RECO_SCRIPT_BLOCK$