Re: Partitioning feature not enabled
- From: Luis Freitas <lfreitas34@xxxxxxxxx>
- To: ora-apps-dba@xxxxxxxxxxxxx
- Date: Mon, 1 Dec 2008 07:56:04 -0800 (PST)
Khayyan,
When you connect to the database using sqlplus, does "Enterprise Edition"
appears to the right of the database version?
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.6.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.6.0 - Production
SQL>
If not, your database binaries are for a standard edition database. This is
the actual binaries on disk, not what is on the database data dictionary.
Also check note 225688.1 for the procedure to enable partitioning if got
the enterprise edition binaries.
Regards,
Luis
--- On Sun, 11/30/08, khabeer khayyam <khabeer1983@xxxxxxxxx> wrote:
From: khabeer khayyam <khabeer1983@xxxxxxxxx>
Subject: Partitioning feature not enabled
To: ora-apps-dba@xxxxxxxxxxxxx
Date: Sunday, November 30, 2008, 7:18 AM
Hi, When I try to partiton a table, it throws the error ORA-00439:
feature not enabled: Partitioning eventhough its an Enterprise Edition
release n the Partition parameter value is set as False in v$option. Though
the PARTITIONING WAS DONE few months ago Does anybody have an idea about
this. Thanks n Regards, Khayyam
Add more friends to your messenger and enjoy! Invite them now.
Other related posts:
