Oracle Data Miner(Installation)

Download oracle data miner from:
http://www.oracle.com/technetwork/database/options/odm/downloads/index.html


from sys user:
--create user:

SQL>CREATE USER dmuser IDENTIFIED BY dmuser

       DEFAULT TABLESPACE USERS

       TEMPORARY TABLESPACE TEMP

       QUOTA UNLIMITED ON USERS;

--grant necessary privileges

SQL>GRANT CREATE JOB TO dmuser;

SQL>GRANT CREATE PROCEDURE TO dmuser;

SQL>GRANT CREATE SEQUENCE TO dmuser;

SQL>GRANT CREATE SESSION TO dmuser;

SQL>GRANT CREATE SYNONYM TO dmuser;

SQL>GRANT CREATE TABLE TO dmuser;

SQL>GRANT CREATE TYPE TO dmuser;

SQL>GRANT CREATE VIEW TO dmuser;

SQL>GRANT EXECUTE ON ctxsys.ctx_ddl TO dmuser;

If the user will need to import or export data mining models, grant this additional privilege.

SQL>GRANT CREATE ANY DIRECTORY TO dmuser;

SQL>@dmshgrants.sql  

Value for 1:sh

Value for 2:dmuser

--from dmuser:

SQL>@dmsh.sql