Skip Headers
Oracle® Database Reference
10g Release 2 (10.2)

Part Number B14237-04
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

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)   Specifies propagation using source queue name and destination queue name
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