Search code examples
oracle11goracle-sqldeveloperdata-mining

Data mining option not showing in view tab in Oracle 11g

I have installed Oracle 11g on my laptop. I opened SQL Developer and created admin and dmuser for data mine. When I tried to create data miner repository, data miner option is not showing up in the "view" tab. Can anyone identify what the problem is? I re-installed 11g and I have been stuck with this

Solution

  • Which 11g edition is it?

    According to documentation (https://www.oracle.com/technetwork/database/options/advanced-analytics/odm/odmrinstallation-2080768.html), you need

    • Data Miner
    • Oracle Text
    • XML DB
    • the SH schema

    All those options are automatically installed along with the Enterprise Edition (otherwise, they are not).

    Then there's SQL Developer where you can create Data Miner Repository, but - first check whether all the prerequisites are met.