-
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
-
well if it's local then you can drop partition without affecting other indexes in other partitions
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|