3.18 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 |
|---|---|---|---|
|
|
|
|
Name of the Streams propagation |
|
|
|
|
Owner of the source queue of the propagation |
|
|
|
|
Name of the source queue of the propagation |
|
|
|
|
Owner of the destination queue of the propagation |
|
|
|
|
Name of the destination queue of the propagation |
|
|
|
|
Database link to propagate events from the source queue to the destination queue |
|
|
|
|
Owner of the propagation positive rule set |
|
|
|
|
Name of the propagation positive rule set |
|
|
|
|
Owner of the propagation negative rule set |
|
|
|
|
Name of the propagation negative rule set |
|
|
|
|
Indicates whether the propagation is a queue-to-queue propagation ( |
|
|
|
|
Status of the propagation:
|
|
|
|
|
Error message last encountered by propagation |
|
|
|
|
Time that propagation last encountered an error |
|
|
|
|
Original propagation from which the propagation is cloned |
|
|
|
|
Source queue owner of the original propagation |
|
|
|
|
Source queue name of the original propagation |
|
|
|
|
Acknowledged SCN of the subscribers of captured messages in the destination queue for the propagation |
|
|
|
|
Merge threshold value for merging the propagation back to the original source queue. This is used as the value for the |
See Also:
-
Oracle Database PL/SQL Packages and Types Reference for more information about the
DBMS_STREAMS_ADM.MERGE_STREAMS_JOBprocedure