Data mining option is enabled by default during installation of Oracle database. However you can verify the settings, enable and disable it after installation.
If you want to enable or disable a database option for an Oracle home, you can use the command-line utility chopt.
Syntax:
chopt [ enable | disable ] db_option_name
Set db_option_name to dm for the Data Mining option.
Steps to Enable Data Mining Option:
STEP 1: Shut down the database:
SQL> shut immediate;
Using srvctl utility for RAC database:
srvctl stop database -d db_name
STEP 2: Stop the database service, OracleServiceSID, using the Services program in Control Panel.
--Only for Windows
STEP 3: Goto ORACLE_HOME directory and execute the below command:
cd $ORACLE_HOME/bin
chopt enable dm
STEP 4: Start the database service, Oracle ServiceSID, using the Services program in Control Panel.
Note: Only for Windows
STEP 5: Start the database:
SQL> startup
For RAC database:
srvctl start database -d db_name
To Verify data mining option click here: Verify DM
SQL> select * from v$option where PARAMETER like '%Data Mining%'
PARAMETER VALUE CON_ID
Data Mining TRUE 0
Steps to Disable Data Mining Option:
STEP 1: Shut down the database:
SQL> shut immediate;
Using srvctl utility for RAC database:
srvctl stop database -d db_name
STEP 2: Stop the database service, OracleServiceSID, using the Services program in Control Panel.
--Only for Windows
STEP 3: Goto ORACLE_HOME directory and execute the below command:
cd ORACLE_HOME/bin
chopt disable dm
STEP 4: Start the database service, Oracle ServiceSID, using the Services program in Control Panel.
Note: Only for Windows
STEP 5: Start the database:
SQL> startup
For RAC database:
srvctl start database -d db_name