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

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 part_on
make -f ioracle

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

This was first published in February 2004

There are Comments. Add yours.

TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: