DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2002

    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
    Madrid, Spain
    well if it's local then you can drop partition without affecting other indexes in other partitions

  3. #3
    Join Date
    Mar 2002
    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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.