Oracle10g Expression Filter Views
The metadata associated with the Expression Filter feature can
be viewed using the Expression Filter views. The Expression Filter
views are defined with a xxx_EXPFIL prefix, where xxx can be USER
or ALL. These views are read-only to the users and are created and
maintained by the Expression Filter APIs.
The following Table lists the names of the views and their
descriptions.
|
VIEW NAME |
DESCRIPTION |
|
user_expfil_aset_functions |
List of functions/packages
approved for the attribute set. |
|
user_expfil_attributes |
List of elementary attributes
of the attribute set. |
|
user_expfil_attribute_sets |
List of attribute set. |
|
user_expfil_def_index_params |
List of default index
parameters. |
|
user_expfil_expression_sets
|
List of expression sets. |
|
user_expfil_exprset_stats |
List of predicate statistics
for the expression sets. |
|
user_expfil_index_params |
List of index parameters
assigned to the expression set. |
|
user_expfil_indexes |
List of expression filter
indexes. |
|
user_expfil_predtab_attributes |
List of stored and indexed
attributes for the indexes. |
|
user_expfil_privileges |
List of all the expression
privileges of the current user. |
Table 6.4 Expression Filter Views
Next, we will look at the new features in SQL Regular
expressions. |
