| Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-03  | 
  | 
  | 
View PDF | 
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 | 
See Also:
"DBA_PROPAGATION"