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

Hello Developer, Hope you guys are doing great. Today at Tutorial Guruji Official website, we are sharing the answer of How to enable Partitioning in oracle 11g (windows 8)? without wasting too much if your time.

The question is published on by Tutorial Guruji team.

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

We are here to answer your question about How to enable Partitioning in oracle 11g (windows 8)? - If you find the proper solution, please don't forgot to share this with your team members.

Related Posts

Tutorial Guruji