DBA Data[Home] [Help] [Dependency Information]

VIEW: SYS._DBA_SXGG_SPLIT_MERGE

Object Details
Object Name: _DBA_SXGG_SPLIT_MERGE
Object Type: VIEW
Owner: SYS
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
ORIGINAL_CAPTURE_NAME VARCHAR2 (128) Yes
CLONED_CAPTURE_NAME VARCHAR2 (128)
ORIGINAL_CAPTURE_STATUS VARCHAR2 (8)
CLONED_CAPTURE_STATUS VARCHAR2 (8)
ORIGINAL_STREAMS_NAME VARCHAR2 (128)
CLONED_STREAMS_NAME VARCHAR2 (128)
STREAMS_TYPE VARCHAR2 (11)
RECOVERABLE_SCRIPT_ID RAW (16)
SCRIPT_STATUS VARCHAR2 (12)
ACTION_TYPE VARCHAR2 (7)
ACTION_THRESHOLD VARCHAR2 (40)
STATUS VARCHAR2 (16)
STATUS_UPDATE_TIME TIMESTAMP(6) (11)
CREATION_TIME TIMESTAMP(6) (11)
LAG NUMBER

JOB_OWNER VARCHAR2 (128)
JOB_NAME VARCHAR2 (128)
JOB_STATE VARCHAR2 (15)
JOB_NEXT_RUN_DATE VARCHAR2 (64)
ERROR_NUMBER NUMBER

ERROR_MESSAGE VARCHAR2 (4000)
PURPOSE VARCHAR2 (19)
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
,      PURPOSE
FROM SYS._DBA_SXGG_SPLIT_MERGE;

Dependencies

[top of page]

SYS._DBA_SXGG_SPLIT_MERGE references the following:

SchemaSYS
ViewDBA_CAPTURE
ViewDBA_SCHEDULER_JOBS
PL/SQL PackageDBMS_LOGREP_UTIL - show dependent code
PL/SQL PackageDBMS_SCHEDULER - show dependent code
FunctionGET_MAX_CHECKPOINT
TableRECO_SCRIPT$
TableSTREAMS$_SPLIT_MERGE
SYS._DBA_SXGG_SPLIT_MERGE is referenced by following:

SchemaSYS
ViewDBA_STREAMS_SPLIT_MERGE
ViewDBA_XSTREAM_SPLIT_MERGE
Package BodyDBMS_STREAMS_AUTO_INT - show dependent code