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

VIEW: SYS.DBA_PROPAGATION

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

Streams propagation in the database

[View Source]

Columns
Name Datatype Length Mandatory Comments
PROPAGATION_NAME VARCHAR2 (128) Yes name of the Streams propagation
SOURCE_QUEUE_OWNER VARCHAR2 (128)
owner of the propgation source queue
SOURCE_QUEUE_NAME VARCHAR2 (128)
name of the propagation source queue
DESTINATION_QUEUE_OWNER VARCHAR2 (128)
owner of the propagation destination queue
DESTINATION_QUEUE_NAME VARCHAR2 (128)
name of the propagation destination queue
DESTINATION_DBLINK VARCHAR2 (128)
database link to access the propagation destination queue
RULE_SET_OWNER VARCHAR2 (128)
propagation rule set owner
RULE_SET_NAME VARCHAR2 (128)
propagation rule set name
NEGATIVE_RULE_SET_OWNER VARCHAR2 (128)
propagation negative rule set owner
NEGATIVE_RULE_SET_NAME VARCHAR2 (128)
propagation negative rule set name
QUEUE_TO_QUEUE VARCHAR2 (5)
STATUS VARCHAR2 (8)
Status of the propagation: DISABLED, ENABLED, ABORTED
ERROR_MESSAGE VARCHAR2 (4000)
Error message last encountered by propagation
ERROR_DATE DATE

The time that propagation last encountered an error
ORIGINAL_PROPAGATION_NAME VARCHAR2 (128)
The original propagation from which this propagation is cloned
ORIGINAL_SOURCE_QUEUE_OWNER VARCHAR2 (128)
The source queue owner of original propagation
ORIGINAL_SOURCE_QUEUE_NAME VARCHAR2 (128)
The source queue name of original propagation
ACKED_SCN NUMBER

AUTO_MERGE_THRESHOLD NUMBER

If not null, merge_streams() will be called on this propagation automatically
Query Text

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


SELECT PROPAGATION_NAME
,      SOURCE_QUEUE_OWNER
,      SOURCE_QUEUE_NAME
,      DESTINATION_QUEUE_OWNER
,      DESTINATION_QUEUE_NAME
,      DESTINATION_DBLINK
,      RULE_SET_OWNER
,      RULE_SET_NAME
,      NEGATIVE_RULE_SET_OWNER
,      NEGATIVE_RULE_SET_NAME
,      QUEUE_TO_QUEUE
,      STATUS
,      ERROR_MESSAGE
,      ERROR_DATE
,      ORIGINAL_PROPAGATION_NAME
,      ORIGINAL_SOURCE_QUEUE_OWNER
,      ORIGINAL_SOURCE_QUEUE_NAME
,      ACKED_SCN
,      AUTO_MERGE_THRESHOLD
FROM SYS.DBA_PROPAGATION;

Dependencies

[top of page]

SYS.DBA_PROPAGATION references the following:

SchemaSYS
ViewDBA_QUEUE_SCHEDULES
PL/SQL PackageDBMS_LOGREP_UTIL - show dependent code
PL/SQL PackageDBMS_SCHEDULER - show dependent code
TableSTREAMS$_PROPAGATION_PROCESS
SYS.DBA_PROPAGATION is referenced by following:

SchemaPUBLIC
SynonymDBA_PROPAGATION
SchemaSYS
ViewALL_PROPAGATION
Package BodyDBMS_CAPTURE_SWITCH_ADM - show dependent code
Package BodyDBMS_CAPTURE_SWITCH_INTERNAL - show dependent code
ProcedureDBMS_FEATURE_STREAMS - show dependent code
ProcedureDBMS_FEATURE_XSTREAM_STREAMS - show dependent code
Package BodyDBMS_LOGREP_EXP - show dependent code
Package BodyDBMS_PROPAGATION_INTERNAL - show dependent code
Package BodyDBMS_STREAMS_ADM_IVK - show dependent code
Package BodyDBMS_STREAMS_ADM_UTL - show dependent code
Package BodyDBMS_STREAMS_AUTO_INT - show dependent code
Package BodyDBMS_STREAMS_SM - show dependent code