Learn how to install Data Mining sample programs.
Follow these steps to install the data mining sample programs:
Install or obtain access to Oracle Database 12c Enterprise Edition with the Advanced Analytics option. To install the Database, see the installation instructions for your platform at
Oracle Database 18c Release.
Verify that Oracle Database Examples has been installed with the database, or install it locally. Oracle Database Examples loads the Database sample programs into the
rdbms/demodirectory under Oracle home. See Oracle Database Examples Installation Guide for installation instructions.
Ask your system administrator to run
dmshgrants.sql, or run it yourself if you have administrative privileges.
dmshgrantsgrants the privileges that are required for running the sample programs. These include
SELECTaccess to tables in the
SHschema as described in "The Data Mining Sample Data" and the system privileges listed in the following table.
Pass the name of the data mining user to
SQL> CONNECT sys / as sysdba Enter password: sys_password Connected. SQL> @ $ORACLE_HOME/rdbms/demo/dmshgrants dmuser
Table A-1 System Privileges Granted by dmshgrants.sql to the Data Mining User
Privilege Allows the data mining user to
log in to a database session
create tables, such as the settings tables for
create views, such as the views of tables in the
CREATE MINING MODEL
create data mining models
EXECUTE ON ctxsys.ctx_ddl
execute procedures in the
ctxsys.ctx_ddlPL/SQL package; required for text mining
Connect to the database as the data mining user and run
dmsh.sql. This script creates views of the sample data in the schema of the data mining user.
SQL> CONNECT dmuser Enter password: dmuser_password Connected. SQL> @ $ORACLE_HOME/rdbms/demo/dmsh