Invalid Objects After Removing OLAP or Migration of a Database to 64 Bit

Doc Id: 565773.1

-> conn / as sysdba
SQL> @?/olap/admin/catnoamd.sql
SQL> @?/olap/admin/olapidrp.plb
SQL> @?/olap/admin/catnoaps.sql
SQL> @?/olap/admin/catnoxoq.sql

Determine all PUBLIC synonyms referring to objects in the OLAPSYS schema:

SQL>spool olapdrop.sql
SQL> select 'drop public synonym ' || synonym_name || ';'
from dba_synonyms
where owner='PUBLIC' and table_owner='OLAPSYS';
SQL>spool off


Modify the datapump handler table to remove handlers used to export OLAP data:

SQL>select * from sys.exppkgact$ where package = 'DBMS_AW_EXP' and
schema= 'SYS';
SQL>delete from sys.exppkgact$ where package = 'DBMS_AW_EXP'
and schema= 'SYS';
SQL>commit;