[Home] [Help] [Dependency Information]
Object Name: | DBA_RECOVERABLE_SCRIPT |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Details about recoverable operations
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
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: EXECUTING, GENERATING | |
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 |
Cut, paste (and edit) the following text to query this object:
SELECT SCRIPT_ID
, CREATION_TIME
, INVOKING_PACKAGE_OWNER
, INVOKING_PACKAGE
, INVOKING_PROCEDURE
, INVOKING_USER
, STATUS
, TOTAL_BLOCKS
, DONE_BLOCK_NUM
, SCRIPT_COMMENT
FROM SYS.DBA_RECOVERABLE_SCRIPT;
|
|
|