Expression Filter and Rules Manager (EXF, RUL) Clean Up in Oracle Database 11.2-12.2

Expression Filter and Rules Manager (EXF, RUL) Clean Up in Oracle Database 11.2-12.2Oracle Expression Filter and Rules Manager (EXF, RUL) clean up in Oracle Database 11.2-12.2 is very simple and straight forward. One script, and several seconds later EXF and RUL are cleaned up. Both options require JAVA to be installed into the database. But their removal doesn’t do anything to JAVA.

Expression Filter and Rules Manager (EXF, RUL) Clean Up in Oracle Database 11.2-12.2

Expression Filter and Rules Manager are obsolete since Oracle Database 12c. You’ll find the official statement in MOS Note: 1233535.1 – Obsolescence Notice: Rules Manager and Expression Filter Features of Oracle Database.

Before you start removing anything from your database please make sure you read my introductory blog post about how to Remove and Clean Up Components from Oracle 11.2 – 12.2 . You’ll find links to monitor proper component removal there as well as in the SQL Scripts Repository on this blog.

Oracle Database 11.2.0.4

Removal from Oracle Database 11g is pretty simple. Execute one script which does neither require any recompilation nor relink nor restart. Please see also MOS Note: 258618.1 – How To Install/Uninstall Expression Filter Feature or EXFSYS  for further information.

$ sqlplus / as sysdba
SQL> @?/rdbms/admin/catnoexf.sql

That’s it.

Oracle Database 12.1.0.2

Expression Filter and Rules Manager components are obsolete in Oracle Database 12.1.0.2.. We remove them as part of the database upgrade.

Oracle Database 12.2.0.1

Expression Filter and Rules Manager components are obsolete in Oracle Database 12.2.0.1.. We remove them as part of the database upgrade.

Component Clean Up Series

Finally download a slide deck about the Component Clean Up on this blog:
https://mikedietrichde.com/slides/

 

Share this: