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

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…

Rules Manager and Expression Filter getting removed

I doubt that many people are using the Oracle features “Rules Manager” and “Expression Filter” as usually people handle these things (such as ensuring that a zip code or a car number plate has a certain format) within the application code and not inside the database. Oracle Beehive for instance uses that just on the side. Anyway, just learned today that Rules Manager and Expression Filter components will get removed once our next database release most likely called Oracle Database 12c will get released. So before upgrading to Oracle Database 12c you can remove EXF and RUL components (SELECT COMP_ID…