Applies to: Oracle Database - Enterprise Edition - Version 11.2.0.1 and later
Information in this document applies to any platform.
Goal
How to enable Partitioning in a Enterprise Edition 11.2 database on Windows? During the original install the Partitioning option had been de-selected.
Solution
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=myDb with srvctl or SQL*Plus:
srvctl stop database -d myDb
2. Stop the database service, OracleServiceSID, using the Services program in
Control Panel.
3. Run the following commands:
cd %ORACLE_HOME%/bin
chopt enable partitioning
4. Start the database service, OracleServiceSID, using the Services program in
Control Panel.
5. Start up the database:
|