CODEWITHSUNDEEP
databasewindowsoracle-databaseoracle11g
Jefferson X Masonic
Jefferson X Masonic

Reputation: 593

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

Upvotes: 2

Views: 15562

Answers (1)

Michal Tenenberg
Michal Tenenberg

Reputation: 518

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".

Upvotes: 5

Related Questions