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