How to remove OLAP组件？

今天在升级一套10204 db时，发现OLAP组件有异常，由于该组件对该系统来讲
无用，故可以remove，查询dba_registry信息如下：

SQL> Col comp_name for a35
SQL> Col status for a15
SQL> Set lines 150
SQL> Select comp_name,version,status from dba_registry;

COMP_NAME                           VERSION          STATUS
----------------------------------- ---------------- ---------------
Oracle Database Catalog Views       10.2.0.4.0       VALID
Oracle Database Packages and Types  10.2.0.4.0       VALID
Oracle Workspace Manager            10.2.0.4.3       VALID
JServer JAVA Virtual Machine        10.2.0.4.0       VALID
Oracle XDK                          10.2.0.4.0       VALID
Oracle Database Java Packages       10.2.0.4.0       VALID
Oracle Expression Filter            10.2.0.4.0       VALID
Oracle Data Mining                  10.2.0.4.0       VALID
Oracle Text                         10.2.0.4.0       VALID
Oracle XML Database                 10.2.0.4.0       VALID
Oracle Rules Manager                10.2.0.4.0       VALID
Oracle interMedia                   10.2.0.4.0       VALID
OLAP Analytic Workspace             10.2.0.4.0       INVALID
Oracle OLAP API                     10.2.0.4.0       INVALID
OLAP Catalog                        10.2.0.4.0       INVALID
Spatial                             10.2.0.4.0       VALID
Oracle Enterprise Manager           10.2.0.4.0       VALID

17 rows selected.

SQL> select VALUE
  2  from v$OPTION
  3  where PARAMETER = 'OLAP';

VALUE
-------------------------------------------
FALSE

SQL> select owner, aw_name from dba_aws;

OWNER                AW_NAME              
-------------------- ----------------------
SYS                  EXPRESS
SYS                  AWMD
SYS                  AWCREATE
SYS                  AWCREATE10G
SYS                  AWXML
SYS                  AWREPORT

6 rows selected.

metalink 上的一篇文档中提供了如何remove OLAP组件的方法，对于10g~11g版本，
执行如下几个sql scripts即可：

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

++++++ 执行完成以后，再次查询dba_registry，将会发现OLAP组件的状态为remove，如下：++++++ 

COMP_NAME                                VERSION           STATUS
---------------------------------------- ----------------- ----------------------
Oracle Database Catalog Views            10.2.0.4.0        VALID
Oracle Database Packages and Types       10.2.0.4.0        VALID
Oracle Workspace Manager                 10.2.0.4.3        VALID
JServer JAVA Virtual Machine             10.2.0.4.0        VALID
Oracle XDK                               10.2.0.4.0        VALID
Oracle Database Java Packages            10.2.0.4.0        VALID
Oracle Expression Filter                 10.2.0.4.0        VALID
Oracle Data Mining                       10.2.0.4.0        VALID
Oracle Text                              10.2.0.4.0        VALID
Oracle XML Database                      10.2.0.4.0        VALID
Oracle Rules Manager                     10.2.0.4.0        VALID
Oracle interMedia                        10.2.0.4.0        VALID
OLAP Analytic Workspace                  10.2.0.4.0        REMOVED
Oracle OLAP API                          10.2.0.4.0        REMOVED
Spatial                                  10.2.0.4.0        VALID
Oracle Enterprise Manager                10.2.0.4.0        VALID

16 rows selected.

如果是10g以前版本，可以使用如下方法：

1) drop the olapsys schema;
2) remove the olap option from a Oracle9i Database:

   {39ecd679003247f2ed728ad9c7ed019a369dd84d0731b449c26bf628d3c1a20b} 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 Find Out If OLAP Is Being Used And How To Remove OLAP [ID 739032.1]
How To Remove the Oracle OLAP API Objects From 9i and 11g Databases [ID 278111.1]