Home » RDBMS Server » Server Administration » Error in Partitioning - 00439
Error in Partitioning - 00439 [message #292946] Thu, 10 January 2008 04:04 Go to next message
durgadas.menon
Messages: 365
Registered: December 2007
Location: Nowhere
Senior Member
Hi,

I am running a standard edition Oracle 9i 2 on Windows 2000 server.
I am trying to partition my table but it is not enabled in this edition.

I want to convert standard edition to personal (or enterprise) so that I can partition tables. How to do that?

Would that have any impact on the current objects in the database?

Thanks in advance

- Das
Re: Error in Partitioning - 00439 [message #292947 is a reply to message #292946] Thu, 10 January 2008 04:07 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You have to reinstall Oracle (and laybe rerun catalog) but it does not impact your objects in the database.

Don't forget to check the partition option during install.

Regards
Michel
Re: Error in Partitioning - 00439 [message #293134 is a reply to message #292947] Fri, 11 January 2008 00:18 Go to previous messageGo to next message
durgadas.menon
Messages: 365
Registered: December 2007
Location: Nowhere
Senior Member
Thanks for the reply

I did reinstall Oracle. Chose the Enterprise Edition. Ran the catproc.sql and catalog.sql file in SYS login but still I am getting the same error

Why do you think this might be happening? How to check which edition I am running currently

- Das
Re: Error in Partitioning - 00439 [message #293141 is a reply to message #293134] Fri, 11 January 2008 00:25 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:

Don't forget to check the partition option during install.

Did you do this?

Quote:

How to check which edition I am running currently

> sqlplus michel/michel

SQL*Plus: Release 10.2.0.3.0 - Production on Fri Jan 11 07:26:30 2008

Copyright (c) 1982, 2006, Oracle.  All Rights Reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production
With the Partitioning, Oracle Label Security, OLAP and Data Mining options

This is the easiest way.

Regards
Michel

[Updated on: Fri, 11 January 2008 00:27]

Report message to a moderator

Re: Error in Partitioning - 00439 [message #293147 is a reply to message #293141] Fri, 11 January 2008 00:35 Go to previous messageGo to next message
durgadas.menon
Messages: 365
Registered: December 2007
Location: Nowhere
Senior Member
Thanks for the reply

I remember that you had mentioned about checking the partition option but while running the Universal installer I did not come across any screen where I could select this option. Have I erred somewhere?

The edition is not written in the 9i I am using (9.2.0.1.0). I downloaded it from the Oracle website. It just shows production

- Das
Re: Error in Partitioning - 00439 [message #293153 is a reply to message #293147] Fri, 11 January 2008 00:43 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:

The edition is not written in the 9i I am using (9.2.0.1.0). I downloaded it from the Oracle website. It just shows production

Then you have installed standard edition.
You also have to check Entreprise Edition box at install time (I didn't mention it, I thought it was obvious).
If you don't have these options then you don't have the correct CD or zip file.

Regards
Michel
Previous Topic: concurrent/session
Next Topic: OLAP Catalog is Invalid
Goto Forum:
  


Current Time: Sat Dec 03 05:58:18 CST 2016

Total time taken to generate the page: 0.09880 seconds