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.STREAMS$_SPLIT_MERGE

Object Details

Object Name:	STREAMS$_SPLIT_MERGE
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_STREAMS_SPLIT_MERGE	NORMAL	UNIQUE	SYSTEM	ORIGINAL_CAPTURE_NAME CLONED_CAPTURE_NAME JOB_NAME JOB_OWNER

Columns

Name	Datatype	Length	Mandatory
ORIGINAL_CAPTURE_NAME	VARCHAR2	(128)	Yes
CLONED_CAPTURE_NAME	VARCHAR2	(128)
ORIGINAL_QUEUE_OWNER	VARCHAR2	(128)
ORIGINAL_QUEUE_NAME	VARCHAR2	(128)
CLONED_QUEUE_OWNER	VARCHAR2	(128)
CLONED_QUEUE_NAME	VARCHAR2	(128)
STREAMS_TYPE	NUMBER
ORIGINAL_STREAMS_NAME	VARCHAR2	(128)
CLONED_STREAMS_NAME	VARCHAR2	(128)
RECOVERABLE_SCRIPT_ID	RAW	(16)
ACTION_TYPE	NUMBER
ACTION_THRESHOLD	NUMBER
ACTIVE	NUMBER
STATUS	NUMBER
STATUS_UPDATE_TIME	TIMESTAMP(6)	(11)
CREATION_TIME	TIMESTAMP(6)	(11)
JOB_OWNER	VARCHAR2	(128)
JOB_NAME	VARCHAR2	(128)
SCHEDULE_OWNER	VARCHAR2	(128)
SCHEDULE_NAME	VARCHAR2	(128)
LAG	NUMBER
ERROR_NUMBER	NUMBER
ERROR_MESSAGE	VARCHAR2	(4000)
SPARE1	NUMBER
SPARE2	NUMBER
SPARE3	NUMBER
SPARE4	NUMBER
SPARE5	VARCHAR2	(4000)
SPARE6	VARCHAR2	(4000)
SPARE7	VARCHAR2	(4000)
SPARE8	VARCHAR2	(4000)
SPARE9	DATE
SPARE10	DATE
SPARE11	DATE
SPARE12	DATE
SPARE13	TIMESTAMP(6)	(11)
SPARE14	TIMESTAMP(6)	(11)
SPARE15	TIMESTAMP(6)	(11)
SPARE16	TIMESTAMP(6)	(11)

Query Text

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


SELECT ORIGINAL_CAPTURE_NAME
,      CLONED_CAPTURE_NAME
,      ORIGINAL_QUEUE_OWNER
,      ORIGINAL_QUEUE_NAME
,      CLONED_QUEUE_OWNER
,      CLONED_QUEUE_NAME
,      STREAMS_TYPE
,      ORIGINAL_STREAMS_NAME
,      CLONED_STREAMS_NAME
,      RECOVERABLE_SCRIPT_ID
,      ACTION_TYPE
,      ACTION_THRESHOLD
,      ACTIVE
,      STATUS
,      STATUS_UPDATE_TIME
,      CREATION_TIME
,      JOB_OWNER
,      JOB_NAME
,      SCHEDULE_OWNER
,      SCHEDULE_NAME
,      LAG
,      ERROR_NUMBER
,      ERROR_MESSAGE
,      SPARE1
,      SPARE2
,      SPARE3
,      SPARE4
,      SPARE5
,      SPARE6
,      SPARE7
,      SPARE8
,      SPARE9
,      SPARE10
,      SPARE11
,      SPARE12
,      SPARE13
,      SPARE14
,      SPARE15
,      SPARE16
FROM SYS.STREAMS$_SPLIT_MERGE;

Dependencies

[top of page]

SYS.STREAMS$_SPLIT_MERGE does not reference any database object

SYS.STREAMS$_SPLIT_MERGE is referenced by following:

SYS: DBMS_STREAMS_AUTO_INT - show dependent code; DBMS_STREAMS_SM - show dependent code; _DBA_SXGG_SPLIT_MERGE; _DBA_SXGG_SPLIT_MERGE_HIST