Ask the Expert

Error creating partitioned table

I am trying to create a partitioned table and I get error ORA-00439, saying that this feature is not enabled. In my SYS.V_$OPTION view my partitioning parameter is set to false.

    Requires Free Membership to View

    Login

Partitioning is only available with Oracle Enterprise Edition. Standard Edition will not support partitioning. So make sure you have the correct software edition installed. After that, you have to perform two basic functions to get partitioning up and running in your database. First, you have to make sure that partitioning is actually installed on your server. To verify this, fire up the Universal Installer. It will tell you if partitioning is installed or not. If not installed, install it. Second, you have to enable partitioning in the database. You do this by shutting down your database and performing the following: 
cd $ORACLE_HOME/rdbms/lib
make -f ins_rdbms.mk part_on
make -f ins_rdbms.mk ioracle

After that, when you start your database, querying V$OPTION should show that paritioning is installed.

This was first published in February 2004

Join the conversationComment

Share
Comments

    Results

    Contribute to the conversation

    All fields are required. Comments will appear at the bottom of the article.
    Back to top