Chopt Tool
Use the chopt
tool after installation to add or remove Oracle Database options.
Purpose
The chopt
tool is a command-line utility that enables and disables database options.
Prerequisites
You must complete installation before you can use the chopt
tool.
File Path
The tool is located in the ORACLE_HOME/bin
directory
Syntax
chopt
[enable
| disable
] db_option
Options
Command Option | Description |
---|---|
oaa |
Oracle Advanced Analytics |
olap |
Oracle OLAP |
partitioning |
Oracle Partitioning |
rat |
Oracle Real Application Testing |
Examples
To use the chopt
tool to modify your Oracle Database, you must shut down the database before you run the chopt
tool, and then start up the database after you add or remove database options.
Example 12-1 Enabling Oracle Data Mining Using Chopt
The following example shows how to use the chopt
tool to enable the Oracle Data Mining option in an Oracle Database called Sales:
cd $ORACLE_HOME/bin
srvctl stop database -d Sales
chopt enable oaa
srvctl start database -d Sales