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



1. Shut down the database SID=ABC with srvctl or SQL*Plus:

srvctl stop database -d ABC 

2. Run the following commands:

cd %ORACLE_HOME%/bin
chopt enable partitioning

3. Start up the database:

srvctl start database -d ABC

On windows we need to do the extra two steps after stopping and before start of the database.




1.a. Stop the database service, OracleServiceSID, using the Services program in
Control Panel. 

2.b. Start the database service, OracleServiceSID, using the Services program in
Control Panel.

Reference: Oracle Docs