I am trying to create Partion table.
When I issued a command it is giving error
ORA-00439: feature not enabled: Partitioning
(Oracle 8i 8.1.6 on Win98)
What should I do??
The compatible initialisation parameter should be set to 8.1.0 or higher.
You performed a new and complete installation of Oracle Enterprise Edition v8.0.4. You are attempting to create a table partition via SQL*Plus when ORA-439 is
The Partition Option may be added to your installation via the Oracle custom installation.
1. Load the Oracle Installer.
2. Select +All Products.
3. Select Oracle Enterprise Edition Cartridges and Options.
4. Select Oracle 8 Partitioning Option.
The SQL*PLUS banner should look like:
Oracle8 Enterprise Edition Release 8.0.4- Production
With the Partitioning and Objects options
PL/SQL Release 8.0.4 - Production
In ur case the phrase "With the Partitioning and Objects options" is missing so u cant create partition table...use the solution given above
The Partition Option was not installed during a complete installation. [QUOTE]Originally posted by Rekha
In case of any help please be free to ask me at firstname.lastname@example.org
Rohit Nirkhe,Oracle DBA,OCP 8i
I have to install oracle again from CD for this??
Click Here to Expand Forum to Full Width