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

Object Details

Object Name:	DBA_RECOVERABLE_SCRIPT
Object Type:	VIEW
Owner:	SYS
Subobject Name:
Status:	VALID

Details about recoverable operations

[View Source]

Columns

Name	Datatype	Length	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

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
FROM SYS.DBA_RECOVERABLE_SCRIPT;

Dependencies

[top of page]

SYS.DBA_RECOVERABLE_SCRIPT references the following:

SYS: RECO_SCRIPT$

SYS.DBA_RECOVERABLE_SCRIPT is referenced by following:

PUBLIC: DBA_RECOVERABLE_SCRIPT
SYS: DBMS_STREAMS_MC - show dependent code; DBMS_STREAMS_MT - show dependent code; DBMS_STREAMS_SM - show dependent code