ALL_PROPAGATION displays information about the Streams propagations that have a source queue accessible to the current user.
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"