DBA_RECOVERABLE_SCRIPT

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(128)

 

Invoking package owner of the operation

INVOKING_PACKAGE

VARCHAR2(128)

 

Invoking package of the operation

INVOKING_PROCEDURE

VARCHAR2(128)

 

Invoking procedure of the operation

INVOKING_USER

VARCHAR2(128)

 

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