Oracle 视图 ALL_PROPAGATION 官方解释，作用，如何使用详细说明
本站中文解释
_RULES 视图
ALL_PROPAGATION_RULES 视图提供了有关Oracle Database上已建立的约束和级联约束的信息。有关使用此视图的说明，请参阅“级联更新和级联删除”。
使用此视图时，您可以查询特定表内约束的触发和关联内容，或查询数据库中所有约束的触发内容。可以使用 ALL_CONS_COLUMNS 视图中的 R_CONS_NAME 列来选取特定约束。
以下语句从 ALL_PROPAGATION_RULES 视图中检索有关某个表的级联更新和级联删除：
SELECT DISTINCT R_CONS_NAME, R_PID, R_TYPE, R_REFERENCED_TABLE, R_REFERENCED_COLUMN, R_UPDATE_ACTION, R_DELETE_ACTION
FROM ALL_PROPAGATION_RULES
WHERE R_CONS_NAME = ‘YOUR_TABLE_CONSTRAINT_NAME’;
官方英文解释
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:
“DBA_PROPAGATION”
