+ Reply to Thread
Results 1 to 10 of 10
  1. 08-21-2003 01:23 AM #1
    yanliu73
    yanliu73 is offline Junior Member
    Join Date
    Aug 2003
    Location
    china
    Posts
    26

    ORA-00439 feature not supported

    ORACLE 9i, when tring to create a bitmap index, I got error :
    ORA-00439 feature not supported. Bit-mapped indexes.

    What's the problem,pls advise.

    Thanks
    Liu Yan
    Reply With Quote Reply With Quote
  2. 08-21-2003 02:12 AM #2
    Janes
    Janes is offline Junior Member
    Join Date
    Aug 2003
    Location
    china
    Posts
    7
    please view the table v$option ,if the parameter 'Bit-mapped indexes' value is false ,you can't create bitmap index .
    Reply With Quote Reply With Quote
  3. 08-21-2003 02:15 AM #3
    ggnanaraj
    ggnanaraj is offline Senior Advisor
    Join Date
    Sep 2000
    Location
    Chennai, India
    Posts
    865
    you need the partitioning option to create bitmap indexes. use custom installation for this.

    HTH.
    Reply With Quote Reply With Quote
  4. 08-21-2003 08:36 AM #4
    patel_dil
    patel_dil is offline Senior Member
    Join Date
    May 2001
    Location
    Maryland, USA
    Posts
    409
    Bitmap Indexes are only available in Enterprise Edition. Are you using Standard Edition?
    -- Dilip
    Reply With Quote Reply With Quote
  5. 08-21-2003 09:10 AM #5
    SANJAY_G's Avatar
    SANJAY_G
    SANJAY_G is offline Senior Advisor
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    Originally posted by ggnanaraj
    you need the partitioning option to create bitmap indexes. use custom installation for this.

    HTH.
    Are you sure about this? AFAIK Bitmap indexes were available even before oracle introduced partitioning.
    I guess is is available only in EE.
    Sanjay G.
    Oracle Certified Professional 8i, 9i.

    "The degree of normality in a database is inversely proportional to that of its DBA"
    Reply With Quote Reply With Quote
  6. 08-22-2003 12:58 AM #6
    yanliu73
    yanliu73 is offline Junior Member
    Join Date
    Aug 2003
    Location
    china
    Posts
    26
    Yes, the database is standard edtion , not enterprise edition.
    What can be done to let the standard edition support bitmap index, or i have to rebuild the database?
    Reply With Quote Reply With Quote
  7. 08-22-2003 01:30 AM #7
    ggnanaraj
    ggnanaraj is offline Senior Advisor
    Join Date
    Sep 2000
    Location
    Chennai, India
    Posts
    865
    Originally posted by SANJAY_G
    Are you sure about this? AFAIK Bitmap indexes were available even before oracle introduced partitioning.
    I guess is is available only in EE.
    Don't know what to say...check this out... http://metalink.oracle.com/metalink/...p_id=1042674.6
    Last edited by ggnanaraj; 08-22-2003 at 01:32 AM.
    Reply With Quote Reply With Quote
  8. 08-22-2003 01:46 AM #8
    yanliu73
    yanliu73 is offline Junior Member
    Join Date
    Aug 2003
    Location
    china
    Posts
    26
    Sorry, i can't get into metalink
    Reply With Quote Reply With Quote
  9. 08-22-2003 03:24 AM #9
    abhaysk's Avatar
    abhaysk
    abhaysk is offline Krishna
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    Originally posted by yanliu73
    Yes, the database is standard edtion , not enterprise edition.
    What can be done to let the standard edition support bitmap index, or i have to rebuild the database?
    Std Edition will not support Bit maps, you gotta install Enterpise Edition..
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"
    Reply With Quote Reply With Quote
  10. 08-22-2003 05:34 AM #10
    TomazZ
    TomazZ is offline Junior Member
    Join Date
    Jul 2001
    Location
    Slovenia
    Posts
    422
    Originally posted by ggnanaraj
    Don't know what to say...check this out... http://metalink.oracle.com/metalink/...p_id=1042674.6
    I don't think this is valid for 9i anymore.
    Tomaž
    "A common mistake that people make when trying to design something completely
    foolproof is to underestimate the ingenuity of complete fools" - Douglas Adams
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Bookmarks

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