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

Object Details

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

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
TABLE_NAME	VARCHAR2	(128)	Yes	Name of the base table for the synchronous refresh
STAGING_LOG_NAME	VARCHAR2	(128)	Yes	Name of the staging log for the synchronous refresh
BAD_ROWID	ROWID	(10)	Yes	Row ID of the staging log row causing the exception for the synchronous refresh
ERROR_NUMBER	NUMBER			Error number of the exception for the synchronous refresh
ERROR_MESSAGE	VARCHAR2	(4000)		Error message of the exception for the synchronous refresh

Query Text

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


SELECT TABLE_NAME
,      STAGING_LOG_NAME
,      BAD_ROWID
,      ERROR_NUMBER
,      ERROR_MESSAGE
FROM SYS.USER_SR_STLOG_EXCEPTIONS;

Dependencies

[top of page]

SYS.USER_SR_STLOG_EXCEPTIONS references the following:

SYS: DBA_SR_STLOG_EXCEPTIONS

SYS.USER_SR_STLOG_EXCEPTIONS is referenced by following:

PUBLIC: USER_SR_STLOG_EXCEPTIONS