I am trying to create a partitioned table and I get error ORA-00439, saying that this feature is not enabled. In...
By submitting your email address, you agree to receive emails regarding relevant topic offers from TechTarget and its partners. You can withdraw your consent at any time. Contact TechTarget at 275 Grove Street, Newton, MA.
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.