Home » RDBMS Server » Server Administration » Partitioning Option not enabled but I'm able to create partitions ??!
Partitioning Option not enabled but I'm able to create partitions ??! [message #58562] Wed, 17 September 2003 01:26 Go to next message
Pit
Messages: 3
Registered: March 2003
Junior Member
Hallo,
I've got the following problem:
We have a partitioned table in our database. We've now wanted to create a local index, but we've got the following error-message:
ORA-00439: Funktion nicht aktiviert: Partitioning
(function not enabled)
The query of v$Option has the result:
partitioning=FALSE
BUT, I can create a new partition on my table.

So, can someone help me?
petra

Report message to a moderator

Re: Partitioning Option not enabled but I'm able to create partitions ??! [message #58582 is a reply to message #58562] Thu, 18 September 2003 14:56 Go to previous message
Sanjay
Messages: 236
Registered: July 2000
Senior Member
Was partitioning installed when Oracle was installed ?Only Ent. Ed. has partitions option available.

I get something like this when I start SqlPlus becoz I have installed 9.2.0 EE with part option

Connected to:
Oracle9i Enterprise Edition Release 9.2.0.3.0 - 64bit Production
With the Partitioning option
JServer Release 9.2.0.3.0 - Production


Good luck.

Report message to a moderator

Previous Topic: DATABASE IMPORT IN THE DEFAULT TABLESPACE OF USER
Next Topic: Oracle10g
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 09:50:29 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.