After the additional installation of Partitioning via Oracle Universal Installer and executing the script you mentioned (and after Oracle restart) I still get ORA-00439 error and V$OPTION still contains Partitioning = FALSE.
Could you help me please? Thank you in advance.
- Shut down all of your Oracle software.
- Change directory to your ORACLE_HOME/bin directory.
- Run the following command:
This will recompile your Oracle executables. If this still does not fix your problem, then explictly state to recompile with partitioning turned on by issuing the following instead of step 3 above:
make -f ins_rdbms.mk part_on
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.