Install the Data Miner Repository Using the GUI

The Oracle by Example tutorial Setting Up Oracle Data Miner 11g Release 2 describes how to install the Data Miner Repository and grants rights to an account. This OBE is available at http://www.oracle.com/webfolder/technetwork/tutorials/obe/db/11g/r2/prod/bidw/datamining/ODM11gR2-SetUp.htm

If you have dropped a Repository, you can reinstall the repository as described in Install Repository Steps.

These steps are described in the tutorial:

  1. Create a Data Miner User Account using SQL Developer

  2. Create a SQL Developer Connection for the Data Miner User

  3. Install the Data Miner Repository

    By default Sample Data is installed. You can deselect loading these tables and views.

    You can Drop the Data Miner Repository Using the GUI if necessary.

When you install the repository, rights are automatically granted to the user account that you connect with.

To grant rights to another account, define a database connection for the account and open the account in the Data Miner navigator. The GUI tells you that the account does not have the correct grants; click OK for the grants to be created. You must log in using an administrative (SYS) account.