35.2 Installing the Data Mining Sample Programs
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
. -
Ensure that the sample schemas are installed in the database. The sample schemas are installed by default with Oracle Database. See Oracle Database Sample Schemasfor details about the sample schemas.
-
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/demo
directory under Oracle home. See Oracle Database Examples Installation Guide for installation instructions. -
Verify that a data mining user account has been created, or create it yourself if you have administrative privileges. See "Creating a Data Mining User".
-
Ask your system administrator to run
dmshgrants.sql
, or run it yourself if you have administrative privileges.dmshgrants
grants the privileges that are required for running the sample programs. These includeSELECT
access to tables in theSH
schema 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
dmshgrants
.SQL> CONNECT sys / as sysdba Enter password: sys_password Connected. SQL> @ $ORACLE_HOME/rdbms/demo/dmshgrants dmuser
Table 35-1 System Privileges Granted by dmshgrants.sql to the Data Mining User
Privilege Allows the data mining user to CREATE SESSION
log in to a database session
CREATE TABLE
create tables, such as the settings tables for
CREATE_MODEL
CREATE VIEW
create views, such as the views of tables in the
SH
schemaCREATE MINING MODEL
create data mining models
EXECUTE ON ctxsys.ctx_ddl
execute procedures in the
ctxsys.ctx_ddl
PL/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