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 |