Ask The Real Tom

October 8, 2009



ORA-00439: feature not enabled: Partitioning

Filed under: oracle — Tags: , , — admin @ 12:07 pm

If you a import a dump on a database without partitioning enabled  you get the error

ORA-00439: feature not enabled: Partitioning

To enable Partitioning shutdown everything in your home and do this.

$ cd $ORACLE_HOME/rdbms/lib
$ make -f ins_rdbms.mk part_on
$ make -f ins_rdbms.mk ioracle

Check it with
 select * from v$option where parameter = 'Partitioning';

Note: This works for 10g and 11g (11.1, 11.2)

Powered by WordPress