Enabling and Disabling Database Options

This is just a short note to point out that starting from Oracle database 11g Release 2, a command line utility, chopt (change option) is available to enable or disable a particular database feature; the tool is located under ORACLE_HOME/bin directory. 

Currently, you can enable or disable the following features using this utility:

  • Oracle Data Mining RDBMS Files,
  • Oracle Database Vault
  • Oracle Label Security
  • Oracle OLAP
  • Oracle Partitioning
  • Oracle Real Application Testing
  • Oracle Database Extensions for .NET 1.x
  • Oracle Database Extensions for .NET 2.0

Leave a Comment

Your email address will not be published. Required fields are marked *

Time limit is exhausted. Please reload the CAPTCHA.