[Translated from mos] how to enable the partition of Oracledatabase Enterprise Edition on windows?
Source:
How to enable Partitioning in Oracle Database Enterprise Edition 11.2 on Windows (Document ID 1188238.1)
Applicable:
Oracle Database-Enterprise Edition-Version 11.2.0.1 and later
Information in this document applies to any platform.
Objectives:
On Windows, how does one enable Oracle database Enterprise Edition partition? During installation, the Partitioning option has been deselected.
Solution:
When you install Oracle 11.2 Enterprise Edition, some options are enabled, while other options are disabled.
If you need to enable or disable a specific databaes feature for an OracleHome, You need to disable the database and use the chopt tool. See the following example:
The chopt tool is a command line tool located in the ORACLE_HOME \ bin directory. The chopt syntax is as follows:
chopt [ enable | disable] db_option
1. Use srvctl or sqlplus to close the database SID = myDb
Srvctl stop database-d myDb
2. Use the Services Program in the control panel: Stop the database Service and OracleServiceSID
3. Run the following command:
cd %ORACLE_HOME%/bin chopt enable partitioning
4. Use the Services Program in the control panel: Start the database Service and OracleServiceSID
5. Start the database
srvctl start database -d myDb
Note:
1. chopt this tool is newly added in 11gR2, which is not available in 10g and 11gR1
2. This article also applies to unix platforms
[oracle@rhel63single ~]$ which lsnrctl/u02/app/oracle/product/11.2.0.4/db_1/bin/lsnrctl[oracle@rhel63single ~]$ which chopt/u02/app/oracle/product/11.2.0.4/db_1/bin/chopt[oracle@rhel63single ~]$ man choptNo manual entry for chopt[oracle@rhel63single ~]$ chopt -helpusage:chopt
options: dm = Oracle Data Mining RDBMS Files dv = Oracle Database Vault option lbac = Oracle Label Security olap = Oracle OLAP partitioning = Oracle Partitioning rat = Oracle Real Application Testinge.g. chopt enable rat[oracle@rhel63single ~]$
3. my understanding of the chopt tool is as follows: it modifies the $ ORACLE_HOME function (that is, Oracle database software). To use this function, you do not need the data dictionary support in the database, it depends on the specific analysis of this function. If you need data dictionary support, you need dbca to run the corresponding script.