DBA Data[Home] [Help] [Dependency Information]

VIEW: SYS.CDB_RECOVERABLE_SCRIPT

Object Details
Object Name: CDB_RECOVERABLE_SCRIPT
Object Type: VIEW
Owner: SYS
Subobject Name:
Status: VALID

Details about recoverable operations in all containers

[View Source]

Columns
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
CON_ID NUMBER

container id
Query Text

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
,      CON_ID
FROM SYS.CDB_RECOVERABLE_SCRIPT;

Dependencies

[top of page]

SYS.CDB_RECOVERABLE_SCRIPT does not reference any database object

SYS.CDB_RECOVERABLE_SCRIPT is referenced by following:

SchemaPUBLIC
SynonymCDB_RECOVERABLE_SCRIPT