Oracle Support Master Note for Oracle Data Mining

The complete and the most recent version of this article can be viewed
from My Oracle Support Knowledge Section.

Master Note for Oracle Data Mining (Doc ID 1087643.1)

Applies to:

Oracle Data Mining - Version: to - Release: 10.1 to 11.2
Information in this document applies to any platform.


This article is intended to assist finding the information for the most
frequently asked questions, and point to the solutions for frequent

Scope and Application


Master Note for Oracle Data Mining


General Information

Oracle Data Mining product home on OTN

Oracle Data Miner

Oracle Data Mining Java API JDeveloper Extension

Oracle Spreadsheet Add-In for Predictive Analytics

Documentation - Licensing


Data Mining as an option in the Oracle Database (11.2, 11.1, 10.2, 10.1)

Feature Availability by Edition (11.2, 11.1, 10.2, 10.1)

Documentation - Guides, References

Administrator's Guide, Application Developer's Guide, Concepts, API Reference (11.2, 11.1, 10.2, 10.1)

DBMS_DATA_MINING package in PL/SQL Packages & Types Reference (11.2, 11.1, 10.2, 10.1)

Data Mining Functions in SQL Language Reference (11.2, 11.1, 10.2)



The Oracle Data Mining Option is installed by default with Oracle Database Enterprise Edition.

Oracle Data Mining Administrators Guide (refer to the Documentation
section above) tells how to install a database and set up a user

Installing Data Miner (10.2 - Oracle by Example tutorial)

Installing Oracle Data Mining Java API JDeveloper Extension

Note 420791.1 How To Manually Install Data Mining (versions -

Note.749821.1 How To Install The Database 11g Examples


Note 297551.1 How To Remove the Data Mining Option from the Database (versions -


The ODM Application Developer's Guide along with the Oracle Data Mining sample codes for various versions gets you started writing SQL- or Java-based data mining applications.

other Data Mining sample programs are installed with Oracle Database
Examples. (Instructions for installing Database Examples and using the
ODM sample programs are in the ODM Administrator's Guide.)

Demonstrations / Viewlets (real life examples including text mining, buyer attribute importance, fraud prediction).

Data Mining Algorithms (a short introduction to the data mining algorithms).

Performance Improvement of Model Building in Oracle 11.1 Data Mining (white paper, May 2008)

Oracle Data Mining Frequently Asked Questions (FAQ) (written for 10g, provides answers to frequently asked overview and technical questions.)


Invalid objects, Data Mining component invalid in the dba_registry

from 11g,  ODM, Oracle Data Mining component is not necessarily appear
in the dba_registry even if the Oracle Data Mining is installed into
the database. In 11g the Data Mining repository is moved under the SYS
schema, and no longer has a dedicated schema (e.g. DMSYS  in 10g) for
it. In case upgrading from earlier version to 11g, once you verified
that the Data Mining upgrade is complete (see documentation), you can
drop the DMSYS schema from the database. Once DMSYS is removed, the
dba_registry will no longer list Oracle Data Mining as a component.

Generic approach to diagnose invalid database objects is discussed in the following note:

NOTE 300056.1 Debug and Validate Invalid Objects

Usually invalid Data Mining objects or component mean improper installation of the Data Mining specific objects into the database. Re-Installing the Data Mining objects into the database manually (see Installation section above) often eliminates the problem.

Other known issues include the following:

Note 373157.1 Data Mining Component Becomes Invalid After EBS Database Upgrade (from version 10.1 to 10.2)

Note 731454.1 Invalid Objects in DMSYS after EBS Database Upgrade (from version 9i to 10.2)

Note 727201.1 Data Mining Invalid After Revoking EXECUTE Permissions On SYS.UTL_FILE / SYS.UTL_HTTP

Note 727867.1 PLS-00201: identifier 'DBMS_RANDOM' must be declared When Compiling Invalid Data Mining Objects

Note 378159.1 Oracle Text breaks if Data Mining is deinstalled

Be the first to comment

Comments ( 0 )
Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.