3.18 ALL_PROPAGATION
ALL_PROPAGATION displays information about the propagations that have a source queue accessible to the current user.
Related View
DBA_PROPAGATION displays information about all propagations in the database.
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
|
|
Name of the 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 |
See Also: