How to enable Partitioning in oracle 11g (windows 8)?

I am getting the Error as:

ORA-00439: feature not enabled: Partitioning while trying to create table with partition.

I have solution for linux and unix systems here:

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

Can any one provide solution for windows ?

Note:

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

PARAMETER
----------------------------------------------------------------
VALUE
----------------------------------------------------------------
Partitioning
FALSE

Thanks

Answer

As mentioned here, if you indeed have the Oracle Enterprise Edition AND the license option for partitioning, you need to enable it through the OUI (Oracle Universal Installer).

Shutdown the database, open the OUI from your Oracle Home, and install “Partitioning”.

Leave a Reply

Your email address will not be published. Required fields are marked *