Bitmap Indexes on Partitions without using LOCAL
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Bitmap Indexes on Partitions without using LOCAL

  1. #1
    Join Date
    Nov 2002
    Location
    Vienna/Austria
    Posts
    1

    Bitmap Indexes on Partitions without using LOCAL


    Hi everybody!

    I created a table with partitions und want to user the so called "user managed partition". That means, i have heard that it is possible to create a bitmap index on this part without using local, like:

    create bitmap index xx_bitmap on table(col)
    (partition p1,...). This doees not work. But if i use
    create bitmap index xx_bitmap on table(col) LOCAL (partition ...) it works. The task is to drop a partition withou affecting another bitmap indexes.

    Has anyone experience to help me to find a nice way


  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    well if it's local then you can drop partition without affecting other indexes in other partitions

  3. #3
    Join Date
    Mar 2002
    Posts
    534
    From the Oracle9i SQL Reference:
    You cannot specify BITMAP when creating a global partitioned index
    Which means that a bitmap index has to be local


    I also got a short question: what benefit do you exepect of having a global bitmapindex?

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