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

Thread: Partition Table

  1. #1
    Join Date
    Oct 2001
    Posts
    34

    Partition Table

    When I create a partition table in my oracle 9i database, the following error occurs:

    create table a (deptno number, deptname varchar2(1))
    partition by range (deptno)
    (partition ab values less than (1))

    *
    ERROR at line 1:
    ORA-00439: feature not enabled: Partitioning


    What happened?
    _____________________________
    Loren

  2. #2
    Join Date
    Apr 2001
    Location
    Bangalore, India
    Posts
    727

    Hi

    Hi

    Same SQL created a table. It seems to be you installation does not support partitioning.

    check select * from v$option;


    Thomas
    Thomas Saviour(royxavier@yahoo.com)
    Technical Lead (Databases)
    Thomson Reuters (Markets)

    http://ora600tom.wordpress.com/

  3. #3
    Join Date
    May 2002
    Posts
    36
    Check if you have installed partitioning with the following query

    select * from v$option where parameter = 'Partitioning';
    You should be able to see the following if partitioning is available.
    PARAMETER VALUE
    ------------- -------------------

    Partitioning TRUE

    If you have not then you will have to reinstall the server with partitioning option.

    Sam

  4. #4
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    Originally posted by samx18
    If you have not then you will have to reinstall the server with partitioning option.
    Sam
    No need to reinstall the whole server. just install the partition option.
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

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