Bitmap Indexes on Partitions without using LOCAL
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
well if it's local then you can drop partition without affecting other indexes in other partitions
From the Oracle9i SQL Reference:
Which means that a bitmap index has to be local
You cannot specify BITMAP when creating a global partitioned index
I also got a short question: what benefit do you exepect of having a global bitmapindex?
Click Here to Expand Forum to Full Width