Oracle DB option Disable /Enable 하는 문서 공유 합니다.
필요할때 발생 시 버전에 맞게 수행 하시면 됩니다.
For Database version 11g Release 2 (11.2.x).
On both Unix and Windows we use the chopt tool (available in 11.2) to disable Oracle Data Mining in the database.
- On Linux/Unix platform as below:
- On Windows platform as below:
For Database version 12c (12.1.x)
CHOPT can be used as per Oracle Document: Enabling and Disabling Database Options
The following example shows how to use the chopt tool to enable and disable the Oracle Data Mining option in an Oracle Database called Sales:
srvctl stop database -d Saleschopt [ enable | disable] dm
srvctl start database -d Sales
For Database version 12.2ODM is part of Oracle Advanced Analytics (OAA).To disable ODM:chopt disable oaa
8.3.6 Enabling and Disabling Database Options
When you install Oracle Database, some options are enabled and others are disabled. To enable or disable a particular database feature for an Oracle home, shut down the database and use the
chopt tool. See Example 8-1.
chopt tool is a command-line utility that is located in the
bin directory. The syntax for
chopt [ enable | disable] db_option
The possible values for
db_option are described in the following table:
||Oracle Data Mining RDBMS Files|
||Oracle Real Application Testing|
Example 8-1 Complete Example of Running the Chopt Tool
To enable the Oracle Data Mining option in your Oracle binary files, use the following command:
cd $ORACLE_HOME/bin srvctl stop database -d myDb chopt enable dm srvctl start database -d myDb