Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Urgent - ORA-00439: feature not enabled: Partitioning - Windows

user530956Oct 27 2010 — edited Oct 27 2010
i have downloaded the 11gr2 and installed in my xp laptop. Strange, i can't see the partition feature enabled. Any clue how to enable the feature in windows? In google search, i can find the solution for unix and linux but not windows


CREATE TABLE T_CUSTOMER
*
ERROR at line 1:
ORA-00439: feature not enabled: Partitioning

SQL> select * from v$version;

BANNER
------------------------------------------------------------------------

Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
PL/SQL Release 11.2.0.1.0 - Production
CORE 11.2.0.1.0 Production
TNS for 32-bit Windows: Version 11.2.0.1.0 - Production
NLSRTL Version 11.2.0.1.0 - Production


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

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

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Nov 24 2010
Added on Oct 27 2010
5 comments
16,099 views