How to remove the Oracle OLAP option from data dictionary in DB 11gR2
Remove OLAP option from data dictionary:
SQL> spool remove_olap.log
—-> Remove OLAP Catalog
SQL> @?/olap/admin/catnoamd.sql
—-> Remove OLAP API
SQL> @?/olap/admin/olapidrp.plb
SQL> @?/olap/admin/catnoxoq.sql
—-> Deinstall APS – OLAP AW component
SQL> @?/olap/admin/catnoaps.sql
SQL> @?/olap/admin/cwm2drop.sql
—-> Recompile invalids
SQL> @?/rdbms/admin/utlrp.sql
SQL> drop public synonym OlapFactView;
SQL> drop public synonym OlapDimView;
SQL> drop public synonym DBMS_ODM;
SQL> spool off
Relink Oracle binaries:
$ cd $ORACLE_HOME/rdbms/lib
$ make -f ins_rdbms.mk olap_off
$ make -f ins_rdbms.mk ioracle