DBA_RECOVERABLE_SCRIPT provides details about recoverable operations.
| Column | Datatype | NULL | Description |
|---|---|---|---|
SCRIPT_ID |
RAW(16) |
Unique ID of the operation | |
CREATION_TIME |
DATE |
Time the operation was invoked | |
INVOKING_PACKAGE_OWNER |
VARCHAR2(30) |
Invoking package owner of the operation | |
INVOKING_PACKAGE |
VARCHAR2(30) |
Invoking package of the operation | |
INVOKING_PROCEDURE |
VARCHAR2(30) |
Invoking procedure of the operation | |
INVOKING_USER |
VARCHAR2(30) |
Script owner | |
STATUS |
VARCHAR2(12) |
State of the recoverable script: GENERATING, NOT EXECUTED, EXECUTING, EXECUTED, or ERROR | |
TOTAL_BLOCKS |
NUMBER |
Total number of blocks for the recoverable script to be executed | |
DONE_BLOCK_NUM |
NUMBER |
Last block executed, thus far | |
SCRIPT_COMMENT |
VARCHAR2(4000) |
Comment for the recoverable script |