Installing the Repository Using a Script

You can install the Oracle Data Miner repository by running the installodmr script.

Verify disk space availability. The Oracle Data Miner repository requires between 200 and 700 MB initially, depending on the tablespace settings.

Note:

For Database 11.2.0.4 or later, the default tablespace for the repository must have auto specified for segment space management.

To install the Oracle Data Miner repository:

1. Log in to the database as SYS.

2. Run the installodmr script.

   installodmr.sql default_tablespace temp_tablespace
   

   For example, if you have set the default search path as described in Setting the Path to Oracle Data Miner Scripts, then the following statement installs the repository with default tablespace USERS and temporary tablespace TEMP:

   @installodmr USERS TEMP

When the database is remote and the repository is using XML DB object-relational storage (Oracle Database 11.2.0.1 - 11.2.0.3), the installation script takes approximately ten minutes to run. When the database is remote and the repository is using binary storage (Oracle Database 11.2.0.4 and later), the installation completes in approximately three minutes.

Note:

After installing the repository, you must enable Oracle Data Miner access for at least one database user.

See Also:

• Storage Configuration for Oracle Data Miner for information about object-relational and binary storage for Oracle Data Miner.

• Granting or Dropping Access Rights to Oracle Data Miner Repository for more information related to enabling or disabling access to the repository.

• About Oracle Data Miner Administration Scriptsbefore running the installation script.