重装 11G(11.2.0.4) OLAP组件

1 删除OLAP

sqlplus /nolog
SQL> conn / as sysdba

----> 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

 

catnoamd.sqlusedabove will drop the OLAPSYS schema (which is completely OLAP specific).

       --catnoamd.sql 脚本用来drop OLAPSYS 用户。

2. 添加OLAP

 SQL> conn /as sysdba
SQL> @?/olap/admin/olap.sql SYSAUX TEMP;

如果有无效对象，使用如下脚本编译：

SQL> @?/rdbms/admin/utlrp.sql