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

VIEW: SYS.DBA_RECOVERABLE_SCRIPT_BLOCKS

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

Details about the recoverable script blocks

[View Source]

Columns
Name Datatype Length Mandatory Comments
SCRIPT_ID RAW (16)
global unique id of the recoverable script to which this block belongs
BLOCK_NUM NUMBER

nth block in the recoverable script to be executed
FORWARD_BLOCK CLOB (4000)
forward block to be executed
FORWARD_BLOCK_DBLINK VARCHAR2 (128)
database where the forward block is executed
UNDO_BLOCK CLOB (4000)
block to rollback the forward operation
UNDO_BLOCK_DBLINK VARCHAR2 (128)
database where the undo block is executed
STATUS VARCHAR2 (12)
status of the block execution - NOT_STARTED, EXECUTING, DONE, ERROR
BLOCK_COMMENT VARCHAR2 (4000)
comment for the block
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT SCRIPT_ID
,      BLOCK_NUM
,      FORWARD_BLOCK
,      FORWARD_BLOCK_DBLINK
,      UNDO_BLOCK
,      UNDO_BLOCK_DBLINK
,      STATUS
,      BLOCK_COMMENT
FROM SYS.DBA_RECOVERABLE_SCRIPT_BLOCKS;

Dependencies

[top of page]

SYS.DBA_RECOVERABLE_SCRIPT_BLOCKS references the following:

SchemaSYS
TableRECO_SCRIPT_BLOCK$
SYS.DBA_RECOVERABLE_SCRIPT_BLOCKS is referenced by following:

SchemaPUBLIC
SynonymDBA_RECOVERABLE_SCRIPT_BLOCKS