Partitioning
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Partitioning

  1. #1
    Join Date
    May 2001
    Posts
    49
    Hi guys
    I am trying to create Partion table.
    When I issued a command it is giving error
    ORA-00439: feature not enabled: Partitioning
    (Oracle 8i 8.1.6 on Win98)
    What should I do??
    Thanks
    Rekha

  2. #2
    Join Date
    Apr 2001
    Posts
    17
    The compatible initialisation parameter should be set to 8.1.0 or higher.

  3. #3
    Join Date
    Feb 2001
    Location
    Bombay,India
    Posts
    530
    Hi Rekha,
    You performed a new and complete installation of Oracle Enterprise Edition v8.0.4. You are attempting to create a table partition via SQL*Plus when ORA-439 is
    reported.

    Solution

    The Partition Option may be added to your installation via the Oracle custom installation.
    1. Load the Oracle Installer.
    2. Select +All Products.
    3. Select Oracle Enterprise Edition Cartridges and Options.
    4. Select Oracle 8 Partitioning Option.

    The SQL*PLUS banner should look like:
    Oracle8 Enterprise Edition Release 8.0.4- Production
    With the Partitioning and Objects options
    PL/SQL Release 8.0.4 - Production

    In ur case the phrase "With the Partitioning and Objects options" is missing so u cant create partition table...use the solution given above


    The Partition Option was not installed during a complete installation. [QUOTE]Originally posted by Rekha



    In case of any help please be free to ask me at rohitsn@altavista.com

    Regards,
    Rohit Nirkhe,Oracle DBA,OCP 8i
    rohitsn@altavista.com

  4. #4
    Join Date
    May 2001
    Posts
    49
    Hi Rohit
    I have to install oracle again from CD for this??
    Thanks
    Rekha

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