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]

TABLE: SYS.XSTREAM$_REPERROR_HANDLER

Object Details

Object Name:	XSTREAM$_REPERROR_HANDLER
Object Type:	TABLE
Owner:	SYS
Subobject Name:
Status:	VALID

Storage Details

Tablespace:	SYSTEM
PCT Free:	10
PCT Used:	40

Indexes

Index	Type	Uniqueness	Tablespace	Column
I_XSTREAM_REPERROR_HANDLER1	NORMAL	UNIQUE	SYSTEM	APPLY_NAME SCHEMA_NAME TABLE_NAME SOURCE_SCHEMA_NAME SOURCE_TABLE_NAME ERROR_NUMBER
SYS_IL0000516782C00018$$	LOB	UNIQUE	SYSTEM

Columns

Name	Datatype	Length	Mandatory
APPLY_NAME	VARCHAR2	(30)	Yes
SCHEMA_NAME	VARCHAR2	(30)	Yes
TABLE_NAME	VARCHAR2	(30)	Yes
SOURCE_SCHEMA_NAME	VARCHAR2	(30)	Yes
SOURCE_TABLE_NAME	VARCHAR2	(30)	Yes
ERROR_NUMBER	NUMBER		Yes
METHOD	NUMBER		Yes
MAX_RETRIES	NUMBER
DELAY_MSECS	NUMBER
SPARE1	NUMBER
SPARE2	NUMBER
SPARE3	NUMBER
SPARE4	TIMESTAMP(6)	(11)
SPARE5	VARCHAR2	(4000)
SPARE6	VARCHAR2	(4000)
SPARE7	RAW	(64)
SPARE8	DATE
SPARE9	CLOB	(4000)
SET_BY	NUMBER

Query Text

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


SELECT APPLY_NAME
,      SCHEMA_NAME
,      TABLE_NAME
,      SOURCE_SCHEMA_NAME
,      SOURCE_TABLE_NAME
,      ERROR_NUMBER
,      METHOD
,      MAX_RETRIES
,      DELAY_MSECS
,      SPARE1
,      SPARE2
,      SPARE3
,      SPARE4
,      SPARE5
,      SPARE6
,      SPARE7
,      SPARE8
,      SPARE9
,      SET_BY
FROM SYS.XSTREAM$_REPERROR_HANDLER;

Dependencies

[top of page]

SYS.XSTREAM$_REPERROR_HANDLER does not reference any database object

SYS.XSTREAM$_REPERROR_HANDLER is referenced by following:

SYS: DBMS_APPLY_ADM_INTERNAL - show dependent code; _DBA_APPLY_REPERROR_HANDLERS