From:
How to enable partitioning in Oracle Database Enterprise Edition 11.2 on Windows (document ID 1188238.1)
Suitable for:
Oracle database-enterprise edition-version 11.2.0.1 and later
Information in this document applies to any platform.
Goal:
How do I enable Oracle Database Enterprise partition on the Windows platform? Partitioning option has been unchecked at the time of installation.
Solution:
When you install Oracle 11.2 Enterprise Edition, some options are enabled and other options are disabled.
If you need to enable or disable a specific Databaes feature for a oraclehome, you need to close the database and use the Chopt tool. See the following example:
The Chopt tool is a command-line tool that is located in the Oracle_home\bin directory, and the syntax for Chopt is as follows:
1. Use Srvctl or sqlplus to close database Sid=mydb
Srvctl Stop database-d MyDb
2. Use the Services Program in Control Panel: Stop database service and ORACLESERVICESID
3. Run the following command:
CD%oracle_home%/bin chopt Enable partitioning
4. Use the Services Program in Control Panel: Start database service and Oracleservicesid
5. Start the database
Srvctl Start database-d myDb
Translator Note:
1.chopt This tool is a newly added tool in 11gr2, not in 10g and 11GR1
2. This article also applies to UNIX platforms
[email protected] ~]$ which lsnrctl/u02/app/oracle/product/11.2.0.4/db_1/bin/lsnrctl[[email protected] ~]$ which Chopt/u02/app/oracle/product/11.2.0.4/db_1/bin/chopt[[email protected] ~]$ man choptno manual entry for Chopt[[email Protected] ~]$ chopt-helpusage:chopt <enable|disable> <option>options: dm = Oracle Data Mining RDBMS Fil ES dv = Oracle Database Vault option lbac = Oracle Label Security OLAP = Oracle OLAP partitioning = Oracle Partitioning
3. My understanding of the Chopt tool is as follows: The $oracle_home function is modified (that is, ORACLE database software), as for the use of this function need not need data dictionary support in database, it needs to see this feature specific analysis, If you need support for a data dictionary, you need to run the appropriate script DBCA.
"Translated from MoS article" How do I enable Oracle Database Enterprise partition on the Windows platform?