How To Install/Uninstall Expression Filter Feature or EXFSYS schema along with Rules Manager (Doc ID 258618.1)

Last updated on DECEMBER 25, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 10.1.0.2 to 12.1.0.2 [Release 10.1 to 12.1]
Information in this document applies to any platform.
***Checked for relevance on 06-Aug-2016***


Goal

Expression Filter (and the related Rules Manager) are installed automatically with Oracle Database 10g Standard Edition and Oracle Database 10g Enterprise Edition and higher. It is supplied as a set of PL/SQL packages, a Java package, a set of dictionary tables, and catalog views. All these objects are created in a dedicated schema named EXFSYS.

Please refer to
Oracle® Database Rules Manager and Expression Filter Developer's Guide
11g Release 2 (11.2)
Appendix: E Installing Rules Manager and Expression Filter
http://docs.oracle.com/cd/E11882_01/appdev.112/e14919/exprn_app_e.htm#EXPRN113


The Expression Filter and related Rules Manager can be seen as installed components in DBA_REGISTRY:

SQL> column comp_id format a16
SQL> column comp_name format a36
SQL> column version format a12
SQL> column status format a7
SQL> select comp_id, comp_name, version, status from dba_registry;

COMP_ID          COMP_NAME                            VERSION      STATUS
---------------- ------------------------------------ ------------ -------
...
EXF              Oracle Expression Filter             11.2.0.1.0   VALID
RUL              Oracle Rules Manager                 11.2.0.1.0   VALID
...

18 rows selected.

SQL>

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms