PACKAGE BODY CWM2_OLAP_INSTALLER created with compilation errors.
While migrating OLAP as a part of oracle database 11.2.0.4 32-bit to 64-bit migration, running %ORACLE_HOME%\olap\admin\olap.sql gives error message:
Warning: Package Body created with compilation errors.
SQL> show errors;
Errors for PACKAGE BODY CWM2_OLAP_INSTALLER:
LINE/COL ERROR
-------- -----------------------------------------------------------------
118/7 PL/SQL: SQL Statement ignored
120/22 PL/SQL: ORA-00942: table or view does not exist
132/7 PL/SQL: SQL Statement ignored
134/22 PL/SQL: ORA-00942: table or view does not exist
SQL> execute sys.cwm2_olap_installer.Validate_CWM2_Install;
BEGIN sys.cwm2_olap_installer.Validate_CWM2_Install; END;
*
ERROR at line 1:
ORA-04063: package body "SYS.CWM2_OLAP_INSTALLER" has errors