eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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	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:

SYS: RECO_SCRIPT_BLOCK$

SYS.DBA_RECOVERABLE_SCRIPT_BLOCKS is referenced by following:

PUBLIC: DBA_RECOVERABLE_SCRIPT_BLOCKS