Pages

Thursday, August 25, 2011

Enable/Disable Optional Oracle 11g Options


In Oracle database 11g, after installation, if you ever want to enable/disable the optional features, just shutdown your database and use the chopt utility as described below. Once done, restart the database and you are all set!

$ORACLE_HOME/chopt

Usage:

chopt <enable|disable> <option>

options:
                  dm = Oracle Data Mining RDBMS Files
                  dv = Oracle Database Vault option
                lbac = Oracle Label Security
                olap = Oracle OLAP
        partitioning = Oracle Partitioning
                 rat = Oracle Real Application Testing

e.g. chopt enable rat

No comments:

Post a Comment