-
Oracle 8i Installation onNT/2000
We wish to user table partition on existing database table, we took export dump, renamed table and try to create new table with partition, but errora message is 'Partition feature is not enabled'.
Now, how to enable this feature? Is there need to re-install the oracle in custom mode and enable partition feature? Is there any impact on existing database?
-
We wish to user table partition on existing database table, we took export dump, renamed table and try to create new table with partition, but errora message is 'Partition feature is not enabled'.
If its Standard Edition then Partitioning Option is not available. In EE Partitioning option should be enabled by default.
Is there need to re-install the oracle in custom mode and enable partition feature?
You can do custom installation and choose partitioning option.
Is there any impact on existing database?
No it wont effect any DB
HTH
Amar
"There is a difference between knowing the path and walking the path."
-
If I am not wrong Partitioning is available only in Enterprise Edition.
Sanjay G.
Oracle Certified Professional 8i, 9i.
"The degree of normality in a database is inversely proportional to that of its DBA"
-
-
Originally posted by adewri
I think i mentioned it
Yeah, I didn't see it because both of us were typing at same time
Sanjay G.
Oracle Certified Professional 8i, 9i.
"The degree of normality in a database is inversely proportional to that of its DBA"
-
Oh i thought you were pointing me
Amar
"There is a difference between knowing the path and walking the path."
-
Thanks Sanjay and Adewri,
Yes, its EE, we will re-install in customize mode and enable the Parition Feature.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|