Printable View
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?
If its Standard Edition then Partitioning Option is not available. In EE Partitioning option should be enabled by default.Quote:
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'.
You can do custom installation and choose partitioning option.Quote:
Is there need to re-install the oracle in custom mode and enable partition feature?
No it wont effect any DBQuote:
Is there any impact on existing database?
HTH
If I am not wrong Partitioning is available only in Enterprise Edition.
I think i mentioned it :)Quote:
Originally posted by adewri
If its Standard Edition then Partitioning Option is not available.
Yeah, I didn't see it because both of us were typing at same time :)Quote:
Originally posted by adewri
I think i mentioned it :)
Oh i thought you were pointing me ;)
Thanks Sanjay and Adewri,
Yes, its EE, we will re-install in customize mode and enable the Parition Feature.