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
Oracle Data Mining - Version: 10.1.0.2 to 220.127.116.11 - 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
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 18.104.22.168 - 22.214.171.124)
Note.749821.1 How To Install The Database 11g Examples
Note 297551.1 How To Remove the Data Mining Option from the Database (versions 126.96.36.199 - 188.8.131.52)
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