Oracle Data Mining 삭제하기

Oracle 을 default 로 설치하면 Data mining option 이 설치되는데, 없애고 싶으면 아래와 같이 하도록 한다.

Oracle Data Mining - Version: 9.2.0.0 to 10.1.0.4

Goal
Data Mining is a Licenced Database Option that is generally installed by default.
This note explains how to remove the Oracle Data Mining option from the Database.

===============================================================================================

Solution
The DBA should be able to deinstall Data Mining from the 'Deinstall' icon on the OUI (Oracle Universal Installer) page. This is a supported way.

If OUI does not work for some reasons, you may do the following to deinstall ODM :

1. Start SQLPLUS and connect with user sys as sysdba

2. Remove ODM repositories from the database :

2.1   For Database release 9iR2 (9.2.x).

      Drop ODM, ODM_MTR schemas using the command :
      SQL>  DROP USER ODM_MTR CASCADE;
      SQL>  DROP USER ODM CASCADE;

2.2  For Database release 10gR1 (10.1.x)
      Drop DMSYS schema using the command :
      SQL>  DROP USER DMSYS CASCADE;

      Followed by :
      SQL> DELETE FROM exppkgact$ WHERE SCHEMA='DMSYS';

3. In a  SQLPLUS session, update the DBA registry :
      SQL>  exec dbms_registry.removed('ODM');

For UNIX Platform the following steps allow to remake Oracle executable without DM libraries

1. Shutdown database
2. cd $ORACLE_HOME/rdbms/lib
3. make -f ins_rdbms.mk dm_off
4. make -f ins_rdbms.mk ioracle
5. bring database up

The sqlplus banner should no longer display the Data Mining option and v$option should show 'Oracle Data Mining' as false on a Unix system based install.

Please note:  It is possible synonyms may exist for Data Mining objects.  If any exist, remove them to complete the removal.