Click to See Complete Forum and Search --> : Bitmap index on Partitioned table


pranavgovind
12-13-2005, 12:29 PM
Dear all,

Can't we create a bitmap index on Partitioned table?.
I have a partition table in datawarehouse environment. I wanted to create a bitmap index. What is the solution for this?

ORA-25122: Only LOCAL bitmap indexes are permitted on partitioned tables


Thanks.

slimdave
12-13-2005, 01:23 PM
Create a local bitmap index, not a global one.