Showing posts with label Partitioning. Show all posts
Showing posts with label Partitioning. Show all posts

Friday, June 22, 2012

Enable/Disable Partitioning in RDBMS Home

When you install Oracle Database 11.2 Enterprise Edition , certain options are enabled and others are disabled.
If you need to enable or disable a particular database feature for an Oracle home, then
shut down the database and use the chopt tool. See Example below:

The chopt tool is a command-line utility that is located in the ORACLE_HOME\bin
directory. The syntax for chopt is as follows:

chopt [ enable | disable] db_option