Oracle 8i Installation onNT/2000
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: Oracle 8i Installation onNT/2000

Hybrid View

  1. #1
    Join Date
    Jun 2003
    Posts
    2

    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?

  2. #2
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796

    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."

    Amar's Blog  Get Firefox!

  3. #3
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    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"

  4. #4
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    Originally posted by adewri
    If its Standard Edition then Partitioning Option is not available.
    I think i mentioned it
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

  5. #5
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    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"

  6. #6
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    Oh i thought you were pointing me
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

  7. #7
    Join Date
    Jun 2003
    Posts
    2
    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
  •  


Click Here to Expand Forum to Full Width