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:
- drop the olapsys schema;
- remove the olap option from a Oracle9i Database:
% sqlplus / nolog
SQL> conn / as sysdba
SQL> @?/cwmlite/admin/onedrop.sql
SQL> @?/olap/admin/olapidrp.sql - 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