Keyword: RULE
jump to Columns back to indexTables
| Table Name | Description |
|---|---|
| ALL_RULES | Rules seen by the user |
| ALL_RULE_SETS | Rule sets seen by the user |
| ALL_RULE_SET_RULES | Rules in all rule sets seen by the user |
| ALL_RULE_SET_RULES | Rules in all rule sets seen by the user |
| ALL_STREAMS_GLOBAL_RULES | Global rules created on the streams capture/apply/propagation process that interact with the queue visible to the current user |
| ALL_STREAMS_SCHEMA_RULES | Rules created by streams administrative APIs on all user schemas |
| ALL_STREAMS_TABLE_RULES | Rules created by streams administrative APIs on tables visible to the current user |
| DBA_RULES | Rules in the databse |
| DBA_RULE_SETS | Rule sets in the database |
| DBA_RULE_SET_RULES | Rules in all rule sets in the database |
| DBA_RULE_SET_RULES | Rules in all rule sets in the database |
| DBA_STREAMS_GLOBAL_RULES | Global rules created by streams administrative APIs |
| DBA_STREAMS_SCHEMA_RULES | Schema rules created by streams administrative APIs |
| DBA_STREAMS_TABLE_RULES | Table rules created by streams administrative APIs |
| USER_RULES | Rules owned by the user |
| USER_RULE_SETS | Rule sets owned by the user |
| USER_RULE_SET_RULES | Rules in user rule sets |
| USER_RULE_SET_RULES | Rules in user rule sets |
Columns
| Column Name | Description |
|---|---|
| DELETE_RULE (USER_CONSTRAINTS) | The delete rule for a referential constraint |
| DELETE_RULE (DBA_CONSTRAINTS) | The delete rule for a referential constraint |
| DELETE_RULE (ALL_CONSTRAINTS) | The delete rule for a referential constraint |
| ELAPSED_RULE_TIME (GV$STREAMS_CAPTURE) | |
| ELAPSED_RULE_TIME (V$STREAMS_CAPTURE) | |
| PUBLISHER_RULE (USER_QUEUE_PUBLISHERS) | |
| PUBLISHER_RULE (ALL_QUEUE_PUBLISHERS) | |
| PUBLISHER_RULE (DBA_QUEUE_PUBLISHERS) | |
| PUBLISHER_RULE_NAME (USER_QUEUE_PUBLISHERS) | |
| PUBLISHER_RULE_NAME (ALL_QUEUE_PUBLISHERS) | |
| PUBLISHER_RULE_NAME (DBA_QUEUE_PUBLISHERS) | |
| RULE_ACTION_CONTEXT (DBA_RULES) | action context of the rule |
| RULE_ACTION_CONTEXT (ALL_RULES) | action context of the rule |
| RULE_ACTION_CONTEXT (USER_RULES) | action context of the rule |
| RULE_COMMENT (USER_RULES) | user description of the rule |
| RULE_COMMENT (DBA_RULES) | user description of the rule |
| RULE_COMMENT (ALL_RULES) | user description of the rule |
| RULE_CONDITION (DBA_STREAMS_GLOBAL_RULES) | Generated rule condition evaluated by the rules engine |
| RULE_CONDITION (USER_RULES) | the rule expression |
| RULE_CONDITION (DBA_RULES) | the rule expression |
| RULE_CONDITION (ALL_RULES) | the rule expression |
| RULE_CONDITION (ALL_STREAMS_SCHEMA_RULES) | Generated rule condition evaluated by the rules engine |
| RULE_CONDITION (DBA_STREAMS_TABLE_RULES) | Generated rule condition evaluated by the rules engine |
| RULE_CONDITION (ALL_STREAMS_GLOBAL_RULES) | Generated rule condition evaluated by the rules engine |
| RULE_CONDITION (ALL_STREAMS_TABLE_RULES) | Generated rule condition evaluated by the rules engine |
| RULE_CONDITION (DBA_STREAMS_SCHEMA_RULES) | Generated rule condition evaluated by the rules engine |
| RULE_EVALUATION_CONTEXT_NAME (ALL_RULES) | name of the evaluation context on which rule is defined |
| RULE_EVALUATION_CONTEXT_NAME (USER_RULES) | name of the evaluation context on which rule is defined |
| RULE_EVALUATION_CONTEXT_NAME (DBA_RULES) | |
| RULE_EVALUATION_CONTEXT_OWNER (DBA_RULES) | |
| RULE_EVALUATION_CONTEXT_OWNER (USER_RULES) | owner of the evaluation context on which rule is defined |
| RULE_EVALUATION_CONTEXT_OWNER (ALL_RULES) | owner of the evaluation context on which rule is defined |
| RULE_NAME (DBA_RULES) | Name of the rule |
| RULE_NAME (ALL_STREAMS_SCHEMA_RULES) | Name of the rule to be applied |
| RULE_NAME (ALL_RULE_SET_RULES) | Name of the rule |
| RULE_NAME (DBA_RULE_SET_RULES) | Name of the rule |
| RULE_NAME (DBA_STREAMS_TABLE_RULES) | Name of the rule to be applied |
| RULE_NAME (DBA_STREAMS_SCHEMA_RULES) | Name of the rule to be applied |
| RULE_NAME (ALL_STREAMS_GLOBAL_RULES) | Name of the rule to be applied |
| RULE_NAME (USER_RULE_SET_RULES) | Name of the rule |
| RULE_NAME (ALL_RULES) | Name of the rule |
| RULE_NAME (ALL_STREAMS_TABLE_RULES) | Name of the rule to be applied |
| RULE_NAME (DBA_STREAMS_GLOBAL_RULES) | Name of the rule to be applied |
| RULE_NAME (USER_RULES) | Name of the rule |
| RULE_OWNER (ALL_RULES) | Owner of the rule |
| RULE_OWNER (DBA_STREAMS_SCHEMA_RULES) | Owner of the rule |
| RULE_OWNER (DBA_RULE_SET_RULES) | Owner of the rule |
| RULE_OWNER (DBA_STREAMS_GLOBAL_RULES) | Owner of the rule |
| RULE_OWNER (ALL_STREAMS_TABLE_RULES) | Owner of the rule |
| RULE_OWNER (DBA_STREAMS_TABLE_RULES) | Owner of the rule |
| RULE_OWNER (ALL_STREAMS_GLOBAL_RULES) | Owner of the rule |
| RULE_OWNER (ALL_STREAMS_SCHEMA_RULES) | Owner of the rule |
| RULE_OWNER (DBA_RULES) | Owner of the rule |
| RULE_OWNER (USER_RULE_SET_RULES) | Owner of the rule |
| RULE_OWNER (ALL_RULE_SET_RULES) | Owner of the rule |
| RULE_SET_COMMENT (USER_RULE_SETS) | user description of the rule set |
| RULE_SET_COMMENT (DBA_RULE_SETS) | user description of the rule set |
| RULE_SET_COMMENT (ALL_RULE_SETS) | user description of the rule set |
| RULE_SET_EVAL_CONTEXT_NAME (USER_RULE_SETS) | The evaluation context name associated with the rule set, if any |
| RULE_SET_EVAL_CONTEXT_NAME (ALL_RULE_SETS) | The evaluation context name associated with the rule set, if any |
| RULE_SET_EVAL_CONTEXT_NAME (DBA_RULE_SETS) | The evaluation context name associated with the rule set, if any |
| RULE_SET_EVAL_CONTEXT_OWNER (USER_RULE_SETS) | The evaluation context owner name associated with the rule set, if any |
| RULE_SET_EVAL_CONTEXT_OWNER (ALL_RULE_SETS) | The evaluation context owner name associated with the rule set, if any |
| RULE_SET_EVAL_CONTEXT_OWNER (DBA_RULE_SETS) | The evaluation context owner name associated with the rule set, if any |
| RULE_SET_NAME (ALL_CAPTURE) | Rule set used by capture process for filtering |
| RULE_SET_NAME (USER_RULE_SETS) | Name of the rule set |
| RULE_SET_NAME (DBA_RULE_SETS) | Name of the rule set |
| RULE_SET_NAME (ALL_RULE_SET_RULES) | Name of the rule set |
| RULE_SET_NAME (DBA_CAPTURE) | Rule set used by capture process for filtering |
| RULE_SET_NAME (USER_RULE_SET_RULES) | Name of the rule set |
| RULE_SET_NAME (ALL_RULE_SETS) | Name of the rule set |
| RULE_SET_NAME (ALL_APPLY) | Rule set used by apply process for filtering |
| RULE_SET_NAME (DBA_APPLY) | Rule set used by apply process for filtering |
| RULE_SET_NAME (DBA_RULE_SET_RULES) | Name of the rule set |
| RULE_SET_NAME (DBA_PROPAGATION) | propagation rule set name |
| RULE_SET_NAME (ALL_PROPAGATION) | propagation rule set name |
| RULE_SET_OWNER (DBA_RULE_SET_RULES) | Owner of the rule set |
| RULE_SET_OWNER (ALL_APPLY) | Owner of the rule set |
| RULE_SET_OWNER (DBA_CAPTURE) | Owner of the rule set |
| RULE_SET_OWNER (DBA_RULE_SETS) | Owner of the rule set |
| RULE_SET_OWNER (ALL_PROPAGATION) | propagation rule set owner |
| RULE_SET_OWNER (ALL_RULE_SETS) | Owner of the rule set |
| RULE_SET_OWNER (DBA_APPLY) | Owner of the rule set |
| RULE_SET_OWNER (ALL_CAPTURE) | Owner of the rule set |
| RULE_SET_OWNER (DBA_PROPAGATION) | propagation rule set owner |
| RULE_SET_OWNER (ALL_RULE_SET_RULES) | Owner of the rule set |
| RULE_SET_RULE_COMMENT (ALL_RULE_SET_RULES) | User description of this mapping |
| RULE_SET_RULE_COMMENT (DBA_RULE_SET_RULES) | User description of this mapping |
| RULE_SET_RULE_COMMENT (ALL_RULE_SET_RULES) | User description of this mapping |
| RULE_SET_RULE_COMMENT (DBA_RULE_SET_RULES) | User description of this mapping |
| RULE_SET_RULE_COMMENT (USER_RULE_SET_RULES) | User description of this mapping |
| RULE_SET_RULE_COMMENT (USER_RULE_SET_RULES) | User description of this mapping |
| RULE_SET_RULE_ENABLED (DBA_RULE_SET_RULES) | Whether the rule is enabled in this ruleset |
| RULE_SET_RULE_ENABLED (USER_RULE_SET_RULES) | Whether the rule is enabled in this ruleset |
| RULE_SET_RULE_ENABLED (USER_RULE_SET_RULES) | Whether the rule is enabled in this ruleset |
| RULE_SET_RULE_ENABLED (ALL_RULE_SET_RULES) | Whether the rule is enabled in this ruleset |
| RULE_SET_RULE_ENABLED (DBA_RULE_SET_RULES) | Whether the rule is enabled in this ruleset |
| RULE_SET_RULE_ENABLED (ALL_RULE_SET_RULES) | Whether the rule is enabled in this ruleset |
| RULE_SET_RULE_EVAL_CTX_NAME (DBA_RULE_SET_RULES) | evaluation context name specified when the rule is added to this rule set |
| RULE_SET_RULE_EVAL_CTX_NAME (DBA_RULE_SET_RULES) | evaluation context name specified when the rule is added to this rule set |
| RULE_SET_RULE_EVAL_CTX_NAME (ALL_RULE_SET_RULES) | evaluation context name specified when the rule is added to this rule set |
| RULE_SET_RULE_EVAL_CTX_NAME (ALL_RULE_SET_RULES) | evaluation context name specified when the rule is added to this rule set |
| RULE_SET_RULE_EVAL_CTX_NAME (USER_RULE_SET_RULES) | evaluation context name specified when the rule is added to this rule set |
| RULE_SET_RULE_EVAL_CTX_NAME (USER_RULE_SET_RULES) | evaluation context name specified when the rule is added to this rule set |
| RULE_SET_RULE_EVAL_CTX_OWNER (USER_RULE_SET_RULES) | evaluation context owner specified when the rule is added to this rule set |
| RULE_SET_RULE_EVAL_CTX_OWNER (DBA_RULE_SET_RULES) | evaluation context owner specified when the rule is added to this rule set |
| RULE_SET_RULE_EVAL_CTX_OWNER (USER_RULE_SET_RULES) | evaluation context owner specified when the rule is added to this rule set |
| RULE_SET_RULE_EVAL_CTX_OWNER (DBA_RULE_SET_RULES) | evaluation context owner specified when the rule is added to this rule set |
| RULE_SET_RULE_EVAL_CTX_OWNER (ALL_RULE_SET_RULES) | evaluation context owner specified when the rule is added to this rule set |
| RULE_SET_RULE_EVAL_CTX_OWNER (ALL_RULE_SET_RULES) | evaluation context owner specified when the rule is added to this rule set |
| RULE_TYPE (ALL_STREAMS_TABLE_RULES) | Type of rule: DML or DDL |
| RULE_TYPE (ALL_STREAMS_SCHEMA_RULES) | Type of rule: DML or DDL |
| RULE_TYPE (DBA_STREAMS_TABLE_RULES) | Type of rule: DML or DDL |
| RULE_TYPE (ALL_STREAMS_GLOBAL_RULES) | Type of rule: DML or DDL |
| RULE_TYPE (DBA_STREAMS_SCHEMA_RULES) | Type of rule: DML or DDL |
| RULE_TYPE (DBA_STREAMS_GLOBAL_RULES) | Type of rule: DML or DDL |