| Oracle® Database Application Developer's Guide - Rules Manager and Expression Filter 10g Release 2 (10.2) Part Number B14288-01 |
|
|
View PDF |
| Oracle® Database Application Developer's Guide - Rules Manager and Expression Filter 10g Release 2 (10.2) Part Number B14288-01 |
|
|
View PDF |
Rules Manager metadata can be viewed using the Rules Manager views defined with a xxx_RLMGR prefix, where xxx can be the string USER or ALL. These views are read-only to users and are created and maintained by the Rules Manager procedures.
Table 8-1 lists the names of the views and their descriptions.
Table 8-1 Rules Manager Views
| View Name | Description |
|---|---|
| USER_RLMGR_EVENT_STRUCTS View |
List of all event structures in the current schema |
| USER_RLMGR_RULE_CLASSES View |
List of all rule classes in the current schema |
| USER_RLMGR_RULE_CLASS_STATUS View |
List of the progress of rule class creation |
| USER_RLMGR_PRIVILEGES View |
List of the privileges for the rule class |
| USER_RLMGR_COMPRCLS_PROPERTIES View |
List of primitive events configured for a rule class and the properties for each event |
The USER_RLMGR_EVENT_STRUCTS view lists all the event structures in the current schema. This view is defined with the columns listed and described in Table 8-2.
Table 8-2 USER_RLMGR_EVENT_STRUCTS View
| Column Name | Data Type | Description |
|---|---|---|
| EVENT_STRUCTURE_NAME | VARCHAR2 | Specifies the name of the event structure |
| HAS_TIMESTAMP | VARCHAR2 | Specifies whether the event structure has the event creation timestamp - YES/NO |
| IS_PRIMITIVE | VARCHAR2 | Specifies whether the event structure is strictly primitive - YES/NO |
The USER_RLMGR_RULE_CLASSES view lists all the rule classes in the current schema. This view is defined with the columns listed and described in Table 8-3.
Table 8-3 USER_RLMGR_RULE_CLASS View
| Column Name | Data Type | Description |
|---|---|---|
| RULE_CLASS_NAME | VARCHAR2 | Name of the rule class |
| ACTION_CALLBACK | VARCHAR2 | The procedure configured as the action callback for the rule class |
| EVENT_STRUCTURE | VARCHAR2 | The event structure used for the rule class |
| RULE_CLASS_PACK | VARCHAR2 | Name of the package implementing the rule class cursors (internal) |
| RCLS_RSLT_VIEW | VARCHAR2 | View to display the matching events and rules for the current session |
| IS_COMPOSITE | VARCHAR2 | Indicates whether the rules class is configured for composite events; if so, the value is YES |
| SEQUENCE_ENB | VARCHAR2 | Indicates whether the rules class is enabled for rule conditions with sequencing; if so, the value is YES |
| AUTOCOMMIT | VARCHAR2 | Indicates whether the rules class is configured for auto-committing events and rules; if so, the value is YES |
| CONSUMPTION | VARCHAR2 | Default Consumption policy for the events in the rule class: valid values are EXCLUSIVE and SHARED |
| DURATION | VARCHAR2 | Default Duration policy of the primitive events |
| ORDERING | VARCHAR2 | Ordering clause used for conflict resolution among matching rules and events |
| EQUAL | VARCHAR2 | Equal specification for the rule classes configured for composite events |
| DML_EVENTS | VARCHAR2 | Types of DML operations enabled for event management |
The USER_RLMGR_RULE_CLASS_STATUS view lists the progress of rule class creation. This view is defined with the columns listed and described in Table 8-4.
The USER_RLMGR_PRIVILEGES view lists the privileges for the rule classes. This view is defined with the columns listed and described in Table 8-5.
Table 8-5 USER_RLMGR_PRIVILEGES View
| Column Name | Data Type | Description |
|---|---|---|
| RULE_CLASS_OWNER | VARCHAR2 | Owner of the rule class |
| RULE_CLASS_NAME | VARCHAR2 | Name of the rule class |
| GRANTEE | VARCHAR2 | Grantee of the privilege. Current user or PUBLIC |
| PRCS_RULE_PRIV | VARCHAR2 | Current user's privilege to execute or process rules |
| ADD_RULE_PRIV | VARCHAR2 | Current user's privilege to add new rules to the rule class |
| DEL_RULE_PRIV | VARCHAR2 | Current user's privilege to delete rules |
The USER_RLMGR_COMPRCLS_PROPERTIES view lists the primitive events configured for a rule class and their properties. This view is defined with the columns listed and described in Table 8-6.
Table 8-6 USER_RLMGR_COMPRCLS_PROPERTIES View
| Column Name | Data Type | Description |
|---|---|---|
| RULE_CLASS_NAME | VARCHAR2 | Name of the rule class configured for composite rules |
| PRIM_EVENT | VARCHAR2 | Name of the primitive event in the composite event |
| PRIM_EVENT_STRUCT | VARCHAR2 | Name of the primitive event structure (object type) |
| HAS_CRTTIME_ATTR | VARCHAR2 | Whether the primitive event structure has the RLM$CRTTIME attribute; if so, the value is YES |
| CONSUMPTION | VARCHAR2 | Consumption policy for the primitive event: valid values are EXCLUSIVE and SHARED |
| TABLE_ALIAS_OF | VARCHAR2 | Table name for the table alias primitive event |
| DURATION | VARCHAR2 | Duration policy for the primitive event |
