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

Object Details

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

Streams propagation in the database in all containers

[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
CON_ID	NUMBER			container id

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
,      CON_ID
FROM SYS.CDB_PROPAGATION;

Dependencies

[top of page]

SYS.CDB_PROPAGATION does not reference any database object

SYS.CDB_PROPAGATION is referenced by following:

PUBLIC: CDB_PROPAGATION