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.ALL_PROPAGATION

Object Details

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

Streams propagation seen by the user

[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)
ORIGINAL_SOURCE_QUEUE_OWNER	VARCHAR2	(128)
ORIGINAL_SOURCE_QUEUE_NAME	VARCHAR2	(128)
ACKED_SCN	NUMBER
AUTO_MERGE_THRESHOLD	NUMBER

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.ALL_PROPAGATION;

Dependencies

[top of page]

SYS.ALL_PROPAGATION references the following:

SYS: ALL_QUEUES; ALL_RULE_SETS; DBA_PROPAGATION; DBMS_LOGREP_UTIL - show dependent code; DBMS_SCHEDULER - show dependent code

SYS.ALL_PROPAGATION is referenced by following:

PUBLIC: ALL_PROPAGATION
SYS: _ALL_STREAMS_PROCESSES