../E40402-16.epub /> ../E40402-16.mobi />

ALL_PROPAGATION

ALL_PROPAGATION displays information about the Streams propagations that have a source queue accessible to the current user.

Related View

DBA_PROPAGATION displays information about all Streams propagations in the database.

Column Datatype NULL Description
PROPAGATION_NAME VARCHAR2(30) NOT NULL Name of the Streams propagation
SOURCE_QUEUE_OWNER VARCHAR2(30)   Owner of the source queue of the propagation
SOURCE_QUEUE_NAME VARCHAR2(30)   Name of the source queue of the propagation
DESTINATION_QUEUE_OWNER VARCHAR2(30)   Owner of the destination queue of the propagation
DESTINATION_QUEUE_NAME VARCHAR2(30)   Name of the destination queue of the propagation
DESTINATION_DBLINK VARCHAR2(128)   Database link to propagate events from the source queue to the destination queue
RULE_SET_OWNER VARCHAR2(30)   Owner of the propagation positive rule set
RULE_SET_NAME VARCHAR2(30)   Name of the propagation positive rule set
NEGATIVE_RULE_SET_OWNER VARCHAR2(30)   Owner of the propagation negative rule set
NEGATIVE_RULE_SET_NAME VARCHAR2(30)   Name of the propagation negative rule set
QUEUE_TO_QUEUE VARCHAR2(5)   Indicates whether the propagation is a queue-to-queue propagation (TRUE) or not (FALSE). A queue-to-queue propagation always has its own exclusive propagation job to propagate messages from the source queue to the destination queue.
STATUS VARCHAR2(8)   Status of the propagation:
  • DISABLED

  • ENABLED

  • ABORTED

ERROR_MESSAGE VARCHAR2(4000)   Error message last encountered by propagation
ERROR_DATE DATE   Time that propagation last encountered an error
ORIGINAL_PROPAGATION_NAME VARCHAR2(30)   Original propagation from which the propagation is cloned
ORIGINAL_SOURCE_QUEUE_OWNER VARCHAR2(30)   Source queue owner of the original propagation
ORIGINAL_SOURCE_QUEUE_NAME VARCHAR2(30)   Source queue name of the original propagation
ACKED_SCN NUMBER   Acknowledged SCN of the subscribers of captured messages in the destination queue for the propagation
AUTO_MERGE_THRESHOLD NUMBER   Merge threshold value for merging the propagation back to the original source queue. This is used as the value for the merge_threshold parameter in the DBMS_STREAMS_ADM.MERGE_STREAMS_JOB procedure.