Skip to main content

How to enable Partitioning in Oracle Database Enterprise Edition 11.2 and higher

How to enable Partitioning in Oracle Database Enterprise Edition 11.2 and higher


When you install Oracle Database 11.2 Enterprise Edition, certain features are enabled by default, while others remain disabled. If you need to enable or disable a specific database feature within an Oracle home, Oracle provides a utility called CHOPT (Change Option Tool).

The CHOPT tool is a simple command-line utility located in the ORACLE_HOME/bin directory. It allows you to customize your database by enabling or disabling certain features based on your requirements.

Syntax for CHOPT

The basic syntax for using CHOPT is as follows:


chopt [enable | disable] db_option

Steps to Enable or Disable a Database Feature

Here’s how you can enable or disable a feature using the CHOPT tool:

  1. Shut Down the Database
    Shut down the database instance using SRVCTL or SQL*Plus:


    srvctl stop database -d myDb

  2. Run the CHOPT Command
    Navigate to the Oracle Home binary directory and execute the CHOPT command:


    cd $ORACLE_HOME/bin  
chopt enable partitioning

    Replace partitioning with the database feature you want to enable or disable.

  3. Start the Database

          srvctl start database -d myDb  

Important Considerations

  • The Partitioning feature is not available for the Enterprise Edition (EE) of Oracle Database on Oracle Cloud Infrastructure (OCI) Database Cloud Service (DBCS EE). It is not supported or allowed to enable Partitioning manually in this environment.

  • If you require Partitioning for your database in Oracle Cloud, you will need a High Performance (DBCS EE-HP) or Extreme Performance (DBCS EE-EP) license. These licenses come with Partitioning and other advanced features enabled by default.


The CHOPT tool is a convenient way to manage database features within an Oracle home. However, for cloud-based environments like Oracle DBCS, always adhere to licensing and support guidelines to avoid conflicts or non-compliance issues. If you need advanced features like Partitioning, ensure you select the appropriate edition (DBCS EE-HP or DBCS EE-EP) during provisioning.





Please do like and subscribe to my youtube channel: https://www.youtube.com/@foalabs If you like this post please follow,share and comment
Labels:

Comments

Post a Comment

Popular posts from this blog

WebLogic migration to OCI using WDT tool

WebLogic migration to OCI using WDT tool Oracle WebLogic Deploy Tool (WDT) is an open-source project designed to simplify and streamline the management of Oracle WebLogic Server domains. With WDT, you can export configuration and application files from one WebLogic Server domain and import them into another, making it a highly effective tool for tasks like migrating on-premises WebLogic configurations to Oracle Cloud. This blog outlines a detailed step-by-step process for using WDT to migrate WebLogic resources and configurations. Supported WLS versions Why Use WDT for Migration? When moving Oracle WebLogic resources from an on-premises environment to Oracle Cloud (or another WebLogic Server), WDT provides an efficient and reliable approach to: Discover and export domain configurations and application binaries. Create reusable models and archives for deployment in a target domain. Key Pre-Requisites Source System: An Oracle WebLogic Server with pre-configured resources such as: Applica...
Post a Comment
Read more

Rename a PDB in Oracle Database Multitenant Architecture in TDE and Non TDE Environment

Rename a PDB in Oracle Database Multitenant Architecture I am sharing a step-by-step guide to help you rename a PDB. This approach uses SQL commands. Without TDE or encryption Wallet Initial Check Check the Current Database Name and Open Mode: SQL > SELECT NAME, OPEN_MODE FROM V$DATABASE; NAME OPEN_MODE --------- -------------------- BEECDB READ WRITE List Current PDBs: SQL > SHOW PDBS; CON_ID CON_NAME OPEN MODE RESTRICTED ---------- ------------------------------ ---------- ---------- 2 PDB$SEED READ ONLY NO 3 FUAT READ WRITE NO We need to RENAME FUAT to BEE  Steps to Rename the PDB Step 1: Export ORACLE_SID Set the Oracle SID to the Container Database (CDB): export ORACLE_SID=BEECDB Step 2: Verify Target PDB Name Availability If the target PDB name is different from the current PDB name, ensure no service exists with the target PDB name. Run SQL to Check Exi...
Post a Comment
Read more

How to make flash work on IE or Edge with IE Compatibility

How to make flash work on IE or Edge with IE Compatibility With flash been ended from 1-Jan-2021, many applications using flash have stopped working the way they were built (like OEM, OBIEE, etc). The option you have to upgrade.  This method will give a workaround in IE or Edge in IE compatibility mode without upgrading. 1. Verify you have installed flash.ocx on your desktop. Typically, flash.ocx file is located in C:\Windows\System32\Macromed\Flash or C:\Windows\SysWOW64\Macromed\Flash according to your laptop OS system. 2. Edit mms.cfg from the location as a System Administrator In the case of the 64bit system, it might have mms.cfg under C:\Windows\SysWOW64\Macromed\Flash 3. Add below options into mms.cfg file. Note: AllowListUrlPattern list is an example. The URLs need to be replaced to your hosts those have Flash pages. SilentAutoUpdateEnable=0 AutoUpdateDisable=1 EOLUninstallDisable=1 EnableAllowList=1 AllowListUrlPattern=http://www.google.com/ AllowListUrlPattern=http://goo...
Post a Comment
Read more