Oracle Data Miner 11.2 SQL Developer 3.1 Release Notes

January 2012

These release notes contain the following information:

  1. Oracle Data Miner 11.2 Functionality
  2. New Features
  3. Before You Start
  4. Support
  5. Getting Started
  6. Migration
  7. Learn How Use Data Miner
  8. General Comments

Oracle Data Miner 11.2 Functionality

Oracle Data Mining, an Oracle Database Enterprise Edition option, provides powerful data mining functionality to leverage data inside an Oracle Database. Oracle Data Miner is the graphical user interface for Oracle Data Mining. Oracle Data Miner is an extension to Oracle SQL Developer 3.0 and 3.1.

Oracle Data Mining enables users to build descriptive and predictive models to:

  • Predict customer behavior
  • Identify promising selling opportunities
  • Identify customer retention risks
  • Discover customer clusters, segments, and profiles
  • Detect anomalous behavior

For more information about Oracle Data Mining, see Oracle Data Mining on Oracle Technology Network.

New Features

Oracle Data Miner that ships with SQL Developer 3.1 includes these features:

  • Globalization support, including translated error messages and GUI for all languages supported by SQL Developer
  • Improved accessibility features including the addition of a Structure navigator that lists all the nodes and links displayed in a workflow
  • Bug fixes

Before You Start

To use Oracle Data Miner, you must connect to an Oracle Database that satisfies these requirements:


  • Oracle Data Mining is installed. Oracle Data Mining is installed automatically when you install Oracle Database Enterprise Edition.
  • Oracle Text is installed. Oracle Text is installed automatically when you install Oracle Database Enterprise Edition.
  • Oracle XML DB is installed. Oracle XML DB is installed automatically when you install Oracle Database Enterprise Edition.
  • Data used by the cue card sets and the Oracle By Example tutorials requires the SH schema. If you install a starter database when you install Oracle Database Enterprise Edition, SH is automatically installed.


Data Miner has two components:

  • The Repository, which runs on an Oracle Database; one repository supports many clients.
  • The Client, which runs on any platform that SQL Developer supports (Windows, Mac, or Linux).


You are supported by Oracle Support under your current Oracle Database Support license. Log Oracle Data Miner bugs and issues using My Oracle Support for the product.

You can discuss installation and use of Oracle Data Miner at Data Mining Forum.

Getting Started

Follow these steps to install the prerequisites for Data Miner and install the Data Miner Repository:

  • Step 1: Install Oracle 11 Release 2 Database.

  • Step 2: Download SQL Developer 3.1 from SQL Developer. Install SQL Developer by unzipping the download to any directory on your system.

  • Step 3: Install Data Miner Repository from the Data Miner GUI by following the Oracle By Example tutorial Setting Up Oracle Data Miner .

    Alternatively, you can install the Data Miner Repository using the Installation Scripts. The installation scripts are in SQLDevHome\sqldeveloper\dataminer\scripts, where SQLDevHome is the directory where you installed SQL Developer. Use of the scripts is optional. The scripts are described in SQLDevHome\sqldeveloper\dataminer\scripts/install_scripts_readme.html and in the online help for Data Miner.

    After you install SQL Developer 3.1, you can also view start up instructions for Data Miner as follows: Select the menu item Help>Table of Contents ; in the Help Center, expand Data Miner Concepts and Usage and then expand Install Oracle Data Miner.


When you initially open a connection from the Data Miner navigator to an existing Data Miner repository, you are prompted to update the repository. The repository update will be performed for you through the GUI-guided process. If you want to run the scripts manually, refer to the installation scripts located in SQLDevHome\sqldeveloper\dataminer\scripts, where SQLDevHome is the directory where SQL Developer is installed.

Learn How to Use Data Miner

Data Miner includes cue cards to illustrate basic usage. Select Help > Table of Contents >Data Miner Cue Cards in Oracle SQL Developer 3.1.

Data Miner also includes Oracle By Example (OBE) tutorials in the Oracle Learning Library at Oracle Data Mining 11g Release 2 OBE Series. The OBEs describe how to set up and use Oracle Data Miner.

General Comments

  • To revoke all the privileges granted to a user for Data Miner, run dropusergrants.sql, included in the Installation Scripts.

  • When you build a model be cautious about turning Automatic Data Processing (ADP) off. Turning ADP off can lead to failures.

  • If you have SELECT privileges to other user tables/views and the SELECT privileges are provided to you via a role, then you will not be able to create views based on that data. This will trigger failures when running the model build nodes and possibly other nodes as well. To avoid these failures, either create a table in your own user account using the Create Table node, or have the DBA or user grant SELECT privileges to you directly rather than through a role.

  • If a workflow appears to be running too long, you can use the Event Viewer to determine the status of the workflow. To open the Event Viewer, click the Event Viewer icon in the workflow tool bar. If the workflow is complete but the UI still shows that the workflow is running, simply close the workflow and reopen it.

  • A performance problem may result if you try to view the Settings tab in the model viewer for a model built using data with nested columns. This problem has been corrected in Oracle Database 11g Release 2 (

  • When you upgrade to Oracle Database 11g Release 2 (, you must also upgrade the ODMRSYS repository so that it is compatible with Release When you start SQL Developer 3.1 after the database upgrade, you are prompted to perform an upgrade for Data Miner. The upgrade process is fully automated in the Data Miner GUI.