5.261 DBA_RECOVERABLE_SCRIPT_BLOCKS

DBA_RECOVERABLE_SCRIPT_BLOCKS provides details about recoverable script blocks.

Column Datatype NULL Description

SCRIPT_ID

RAW(16)

Global unique ID of the recoverable script to which this block belongs

BLOCK_NUM

NUMBER

The nth block in the recoverable script to be executed

FORWARD_BLOCK

CLOB

Forward block to be executed

FORWARD_BLOCK_DBLINK

VARCHAR2(128)

Database where the forward block is executed

UNDO_BLOCK

CLOB

Block to roll back the forward operation

UNDO_BLOCK_DBLINK

VARCHAR2(128)

Database where the undo block is executed

STATUS

VARCHAR2(12)

Status of the block execution: GENERATING, NOT EXECUTED, EXECUTING, EXECUTED, or ERROR

BLOCK_COMMENT

VARCHAR2(4000)

Comment for the block