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.CDB_RECOVERABLE_SCRIPT_HIST

Object Details

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

Details about executed or purged recoverable operations in all containers

[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
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_HIST;

Dependencies

[top of page]

SYS.CDB_RECOVERABLE_SCRIPT_HIST does not reference any database object

SYS.CDB_RECOVERABLE_SCRIPT_HIST is referenced by following:

PUBLIC: CDB_RECOVERABLE_SCRIPT_HIST