Installing the Oracle Data Miner Repository

Oracle Autonomous Database is configured with an administrator account ADMIN, which is used to create and manage other database accounts. Direct access to the SYS account in Autonomous Database is not available. Therefore, you cannot install the Data Miner Repository using the Data Miner connection in the SQL Developer interface on Oracle Autonomous Database since it requires access to the SYS account.

Oracle Autonomous Database is configured with an administrator account ADMIN, which is used to create and manage other database accounts. Direct access to the SYS account in Autonomous Database is not available. Therefore, you cannot install the Data Miner Repository using the Data Miner connection in the SQL Developer interface on Oracle Autonomous Database since it requires access to the SYS account.

• Use the installodmr.sql script to install the Data Miner repository
• Use the low service level only

1. In SQL Developer, go to Tools and click SQL Worksheet. Select the connection to Oracle Autonomous Database that you created here.
   The SQL Worksheet opens.
2. Use the double @@ symbol to run the installodmr.sql script from the SQL Developer home directory sqldeveloper/dataminer/scripts. Alternatively, you may use a single @ symbol and specify the full path to the installodmr.sql script as shown below:

   @@installodmr.sql DATA TEMP

   Here, DATA and TEMP are the default user and temp tablespaces in Oracle Autonomous Database.

   Figure 4-3 Installing Oracle Data Miner Repository

   
   On MacOS you can change the default path to scripts temporarily by clicking on the Oracle SQL Developer main menu, then select Preferences, Database, then Worksheet, and under the field Select default path to look for scripts enter the following: /Applications/SQLDeveloper.app/Contents/Resources/sqldeveloper/dataminer/scripts. This will allow you to run the scripts by just using the double at symbol and the name of the script.

This completes the task of installing the Data Miner repository. Nest, you must grant the required privileges to the user to start using Oracle Data Miner.