VIEW: SYS.DBA_RECOVERABLE_SCRIPT

Source

View Text - Preformatted

select oid, ctime, invoking_package_owner, invoking_package,
  invoking_procedure, invoking_user,
  decode(status, 1, 'GENERATING',
                 2, 'NOT EXECUTED',
                 3, 'EXECUTING',
                 4, 'EXECUTED',
                 5, 'ERROR'),
  total_blocks, done_block_num, script_comment
from sys.reco_script$
where status in (1,2,3,5)

View Text - HTML Formatted

SELECT OID
, CTIME
, INVOKING_PACKAGE_OWNER
, INVOKING_PACKAGE
, INVOKING_PROCEDURE
, INVOKING_USER
, DECODE(STATUS
, 1
, 'GENERATING'
, 2
, 'NOT EXECUTED'
, 3
, 'EXECUTING'
, 4
, 'EXECUTED'
, 5
, 'ERROR')
, TOTAL_BLOCKS
, DONE_BLOCK_NUM
, SCRIPT_COMMENT FROM SYS.RECO_SCRIPT$ WHERE STATUS IN (1
, 2
, 3
, 5)