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_HIST

Object Details

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

Details about executed or purged 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	(8)	state of the recoverable script: EXECUTED, PURGED
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_HIST;

Dependencies

[top of page]

SYS.DBA_RECOVERABLE_SCRIPT_HIST references the following:

SYS: RECO_SCRIPT$

SYS.DBA_RECOVERABLE_SCRIPT_HIST is referenced by following:

PUBLIC: DBA_RECOVERABLE_SCRIPT_HIST
SYS: DBMS_STREAMS_AUTO_INT - show dependent code