Oracle 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
- Remove and Clean Up Components from Oracle 11.2 – 12.2 – General Guidelines and Precautions
- APEX – Oracle Application Express Clean Up
- OWM – Oracle Workspace Manager Clean Up
- DV – Oracle Database Vault Clean Up
- OLS – Oracle Label Security Clean Up
- SDO – Oracle Spatial Data Option Clean Up
- CONTEXT – Oracle Text Clean Up
- ORDIM – Oracle Multi Media Clean Up
- XOQ – Oracle OLAP API Clean Up
- APS – Oracle OLAP Analytical Workspace Clean Up
- AMD – Oracle OLAP Catalog Clean Up
- OWB – Oracle Warehouse Builder Clean Up
- EXF/RUL – Oracle Expression Filters and Rules Manager Clean Up
- EM – Enterprise Manager Database Control Clean Up
- JAVAVM/XML – Oracle Java Virtual Machine and XDK Clean Up
- XDB – Oracle XML Database Clean Up
Finally download a slide deck about the Component Clean Up on this blog:
https://mikedietrichde.com/slides/
Apparently EXF can be installed under 12.1.0.2 using the EXF creation procedure from 11.2.
Found EXF installed with status ‘VALID’ in several of our customer’s 12.1.0.2 databases by the customer’s application supplier/manufacturer.
EXF was removed previously as part of the upgrade from 11.2 to 12.1.0.2 in said databases.
catnoexf.sql removed the component but now I have have EXFSYS database user/schema leftovers in these databases.
Pls advise if these EXFSYS can be safely removed? Or do I open an SR,
Hi Christian,
there was an underscore I don’t remember to prevent the removal during the upgrade to 12.1.
I have never tried to install it into 12.1 but technically it works as the underscore came in for an important system.
And yes, you can safely remove it unless a software relies on it (which shouldn’t the case in 12.1 onwards anymore).
Cheers,
Mike
Moin Mike,
Thanks for the reply.
I have removed it using the “catnoexf.sql” but it left some remnant: there is a database user/schema “EXFSYS” left over after “catnoexf.sql” which I am not sure about to simply drop.
A fresh 12.1.0.2 database having the same components as the database in question does not possess the schema “EXFSYS”.
What I am mainly concerned about are complications during a coming 19c upgrade as regards to that EXFSYS user.
Best Regard,
Christian
Hi Christian,
drop it please.
Cheers,
Mike