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

Note:

When you enable or disable OLAP, you must run the SYS.XOQ_VALIDATE and SYS.APS_VALIDATE procedures to update the database registry. When you disable OLAP, its status in the database registry should be OPTION OFF and when you enable OLAP, its status in the database registry should be VALID.

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 11-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