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”
