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
:confused: