My Oracle Support Banner

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

Last updated on SEPTEMBER 23, 2018

Applies to:

Oracle Database - Enterprise Edition - Version to [Release 10.1 to 12.1]
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Information in this document applies to any platform.
***Checked for relevance on 06-Aug-2016***


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

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      VALID
RUL              Oracle Rules Manager          VALID

18 rows selected.



To view full details, 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 a vibrant support community of peers and Oracle experts.