How to enable Partitioning in Oracle Database Enterprise Edition 11.2 on Wind...

郑全

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: