Installing the Repository Using SQL Developer GUI

You can install the Oracle Data Miner repository using the SQL Developer graphical user interface.

Before you install the repository, verify disk space availability. You must have 4 MB disk space for initial storage allocation. For additional storage, you must have an average of 1 MB disk space to handle 10 workflows of 20 nodes each.

To install the Oracle Data Miner repository from SQL Developer GUI:

1. In the Connections tab of SQL Developer, select an administrative connection to the target database, or create a new one.

2. Create an Oracle Data Miner user:

   1. Drill on the administrative connection.

   2. Right click Other Users and choose Create User.

   3. Grant the CONNECT role to the user, and for Default Tablespace, specify Unlimited Quota.

3. In the Connections tab, create a connection for the Oracle Data Miner user.

4. From the View menu, select Data Miner, and then Data Miner Connections.

5. The Data Miner Connections tab appears beneath the SQL Developer Connections tab.

6. Click the plus sign on the Data Miner tab to display the Select Connection dialog box. Choose the Data Miner user from the drop-down list.

7. The new connection appears on the Data Miner tab.

8. When you attempt to drill on the new connection, this dialog box is displayed:

   Figure 3-1 Repository not Installed

   
   Description of "Figure 3-1 Repository not Installed"

9. Click Yes to install the repository.

10. After you provide the SYS password, information about the repository is displayed. For example:

    Figure 3-2 Repository Installation Settings

    
    Description of "Figure 3-2 Repository Installation Settings"

11. Click OK.

12. The Repository Installation Settings dialog box appears.

    Select the Install Demo Data check box to install the sample data in the schema of the user connection. If the SH schema is present in the database, then all sample data is installed. If SH is not installed, then only ODMR_CARS_DATA, INSUR_CUST_LVT_SAMPLE, ODMR_SALES_JSON_DATA ODMR_MINING_DATA_TEXT, ODMR_SALES_DATA, and WIKISAMPLE (Database 12.1 only) are installed.

    Figure 3-3 Install Data Miner Repository

    
    Description of "Figure 3-3 Install Data Miner Repository"

    Note:

    The repository installation automatically grants the database privileges required by Oracle Data Miner.

    The privileges required by Oracle Data Miner are different from the privileges required for using the Oracle Data Mining APIs directly. For details, see "Controlling Access to Mining Models and Data" in Oracle Data Mining Application Developer’s Guide.

13. When the installation is complete, click Close.