5.257 DBA_RECOVERABLE_SCRIPT_HIST

DBA_RECOVERABLE_SCRIPT_HIST displays details about executed or purged 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(8)

state of the recoverable script: EXECUTED, PURGED

TOTAL_BLOCKS

NUMBER

total number of blocks for the recoverable script to be executed

DONE_BLOCK_NUM

NUMBER

last block so far executed

SCRIPT_COMMENT

VARCHAR2(4000)

comment for the recoverable script