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!

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,368 views