| Error in Partitioning - 00439 [message #292946] |
Thu, 10 January 2008 04:04  |
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 #293134 is a reply to message #292947] |
Fri, 11 January 2008 00:18  |
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 |
 |
Michel Cadot
Messages: 68683
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 |
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 |
|
Michel Cadot
Messages: 68683
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
