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

Thread: Partitioning

  1. 05-13-2001, 06:41 PM #1
    Rekha
    Rekha is offline Junior Member
    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
    Reply With Quote Reply With Quote
  2. 05-13-2001, 11:59 PM #2
    kong
    kong is offline Junior Member
    Join Date
    Apr 2001
    Posts
    17
    The compatible initialisation parameter should be set to 8.1.0 or higher.
    Reply With Quote Reply With Quote
  3. 05-14-2001, 03:44 AM #3
    rohitsn
    rohitsn is offline Advisor
    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
    Reply With Quote Reply With Quote
  4. 05-14-2001, 11:45 AM #4
    Rekha
    Rekha is offline Junior Member
    Join Date
    May 2001
    Posts
    49
    Hi Rohit
    I have to install oracle again from CD for this??
    Thanks
    Rekha
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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