The Expression Filter DBMS_EXPFIL package contains all the procedures used to manage attribute sets, expression sets, expression indexes, optimizer statistics, and privileges. Table 17-1 describes the procedures in the DBMS_EXPFIL package. These procedures are further described in this chapter.
None of the values and names passed to the procedures defined in the DBMS_EXPFIL package are case sensitive, unless otherwise mentioned. To preserve the case, use double quotation marks around the values.
Tip:
See the "DBMS_EXPIL" chapter in Oracle Database PL/SQL Packages and Types Reference for all reference information concerning Expression Filter package procedures.Table 17-1 DBMS_EXPFIL Procedures
| Procedure | Description |
|---|---|
|
Adds the specified attribute to the attribute set |
|
|
Adds a function, type, or package to the approved list of functions with an attribute set |
|
|
Assigns an attribute set to a column storing expressions |
|
|
Creates an exception table to hold references to invalid expressions |
|
|
Clears the predicate statistics for an expression set |
|
|
Makes a copy of the attribute set |
|
|
Creates an attribute set |
|
|
Assigns default index parameters to an attribute set |
|
|
Assigns default XPath index parameters to an attribute set |
|
|
Rebuilds the bitmap indexes online to reduce fragmentation |
|
|
Drops an unused attribute set |
|
|
Collects predicate statistics for an expression set |
|
|
Grants an expression DML privilege to a user |
|
|
Assigns index parameters to an expression set |
|
|
Modifies the list of common operators associated with a certain attribute in the attribute set |
|
|
Revokes an expression DML privilege from a user |
|
|
Breaks the association between a column storing expressions and the attribute set |
|
|
Validates expression metadata and the expressions stored in a column |
|
|
Assigns XPath index parameters to an expression set |