How To Remove the Oracle OLAP API Objects From 9i and 11g Databases (Doc ID 278111.1)

How to remove the Oracle OLAP API objects from a 9i database

We can consider like olap api objects:

-) objects in the schema of olapsys;
-) public synonyms for objects or packages in the olapsys schema;
-) some objects in the system schema;

In order to remove them from the database, you can carry out the following ways:

1. drop the olapsys schema;
2. remove the olap option from a Oracle9i Database:
   % sqlplus / nolog
   SQL> conn / as sysdba
   SQL> @?/cwmlite/admin/onedrop.sql
   SQL> @?/olap/admin/olapidrp.sql
3. create the database using the Database Creation Assistant (dbca)
   and then remove the olap script from the list of scripts to be executed.

How to Remove OLAP option from a Oracle Database 10g and 11g

SQL> @?/olap/admin/catnoamd.sql
SQL> @?/olap/admin/olapidrp.plb
SQL> @?/olap/admin/catnoaps.sql
SQL> @?/olap/admin/catnoxoq.sql
SQL> @?/olap/admin/cwm2drop.sql

For further complete removal it needs to unlink from the Oracle binary,
in this case, ensure a backup is in place.

DO NOT PERFORM THE FOLLOWING STEP IF YOU INTEND TO REINSTALL OLAP OR HAVE OLAP IN ANOTHER INSTANCE IN THE SAME ORACLE HOME.

% sqlplus / as sysdba
SQL> shutdown immediate
SQL> exit
% cd $ORACLE_HOME/rdbms/lib
% make -f ins_rdbms.mk olap_off
% make -f ins_rdbms.mk ioracle
% sqlplus / as sysdba
SQL> startup