Q

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. 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

Dig deeper on Oracle database design and architecture

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

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:

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close