Problem solve Get help with specific problems with your technologies, process and projects.

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.

Dig Deeper on Oracle database design and architecture

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.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.