Skip Headers
Oracle® Database Rules Manager and Expression Filter Developer's Guide
11g Release 1 (11.1)

Part Number B31088-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
View PDF

9 Rules Manager Views

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 9-1 lists the names of the views and their descriptions.

Table 9-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


9.1 USER_RLMGR_EVENT_STRUCTS View

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 9-2.

Table 9-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

TABLE_ALIAS_OF

VARCHAR2

Table name for a table alias primitive event

CONDITIONS_TABLE

VARCHAR2

Name of the table that stores the sharable conditions for this event structure


9.2 USER_RLMGR_RULE_CLASSES View

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 9-3.

Table 9-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 rule class is configured for composite events; if so, the value is YES

SEQUENCE_ENB

VARCHAR2

Indicates whether the rule class is enabled for rule conditions with sequencing; if so, the value is YES

AUTOCOMMIT

VARCHAR2

Indicates whether the rule 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

CNF_EVENTS

VARCHAR2

Types of Change Notifications enabled for event management


9.3 USER_RLMGR_RULE_CLASS_STATUS View

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 9-4.

Table 9-4 USER_RLMGR_RULE_CLASS_STATUS View

Column Name Data Type Description

RULE_CLASS_NAME

VARCHAR2

Name of the rule class

STATUS

VARCHAR2

Current status of the rule class

STATUS_CODE

VARCHAR2

Internal code for the status

NEXT_OPERATION

VARCHAR2

Next operation performed on the rule class


9.4 USER_RLMGR_PRIVILEGES View

The USER_RLMGR_PRIVILEGES view lists the privileges for the rule classes. This view is defined with the columns listed and described in Table 9-5.

Table 9-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


9.5 USER_RLMGR_COMPRCLS_PROPERTIES View

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 9-6.

Table 9-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

COLLECTION_ENB

VARCHAR2

Is the primitive event enabled for collections?

GROUPBY_ATTRIBUTES

VARCHAR2

Event attributes that may be used for GROUPBY clauses