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_STREAMS_SPLIT_MERGE

Object Details

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

view of details of split/merge jobs/status about streams

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ORIGINAL_CAPTURE_NAME	VARCHAR2	(128)	Yes	name of the original capture
CLONED_CAPTURE_NAME	VARCHAR2	(128)		name of the cloned capture
ORIGINAL_CAPTURE_STATUS	VARCHAR2	(8)		status of the original capture
CLONED_CAPTURE_STATUS	VARCHAR2	(8)		status of the cloned capture
ORIGINAL_STREAMS_NAME	VARCHAR2	(128)		name of original streams (propagation or local apply)
CLONED_STREAMS_NAME	VARCHAR2	(128)		name of cloned streams (propagation or local apply)
STREAMS_TYPE	VARCHAR2	(11)		type of streams (propagation or local apply)
RECOVERABLE_SCRIPT_ID	RAW	(16)		unique oid of the script to split or merge streams
SCRIPT_STATUS	VARCHAR2	(12)		status of the script to split or merge streams
ACTION_TYPE	VARCHAR2	(7)		type of action performed on this streams (either split or merge)
ACTION_THRESHOLD	VARCHAR2	(40)		value of split_threshold or merge_threshold
STATUS	VARCHAR2	(16)		status of streams
STATUS_UPDATE_TIME	TIMESTAMP(6)	(11)		time when status was last updated
CREATION_TIME	TIMESTAMP(6)	(11)		time when this row was created
LAG	NUMBER			the time in seconds that the cloned capture lags behind the original capture
JOB_OWNER	VARCHAR2	(128)		name of the owner of the job
JOB_NAME	VARCHAR2	(128)		name of the job to split or merge streams
JOB_STATE	VARCHAR2	(15)		state of the job
JOB_NEXT_RUN_DATE	VARCHAR2	(64)		when will the job run next time
ERROR_NUMBER	NUMBER			Error number if the capture process was aborted
ERROR_MESSAGE	VARCHAR2	(4000)		Error message if the capture process was aborted

Query Text

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


SELECT ORIGINAL_CAPTURE_NAME
,      CLONED_CAPTURE_NAME
,      ORIGINAL_CAPTURE_STATUS
,      CLONED_CAPTURE_STATUS
,      ORIGINAL_STREAMS_NAME
,      CLONED_STREAMS_NAME
,      STREAMS_TYPE
,      RECOVERABLE_SCRIPT_ID
,      SCRIPT_STATUS
,      ACTION_TYPE
,      ACTION_THRESHOLD
,      STATUS
,      STATUS_UPDATE_TIME
,      CREATION_TIME
,      LAG
,      JOB_OWNER
,      JOB_NAME
,      JOB_STATE
,      JOB_NEXT_RUN_DATE
,      ERROR_NUMBER
,      ERROR_MESSAGE
FROM SYS.DBA_STREAMS_SPLIT_MERGE;

Dependencies

[top of page]

SYS.DBA_STREAMS_SPLIT_MERGE references the following:

SYS: DBMS_LOGREP_UTIL - show dependent code; DBMS_SCHEDULER - show dependent code; GET_MAX_CHECKPOINT; _DBA_SXGG_SPLIT_MERGE

SYS.DBA_STREAMS_SPLIT_MERGE is referenced by following:

PUBLIC: DBA_STREAMS_SPLIT_MERGE