Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Creating a bit map index on a partitioned table

431033Oct 12 2004 — edited Oct 13 2004

Dear friends,
I am trying to create a bitmap index on a partitioned table but am receiving the following ORA error. Can you please let me know on how to create a local bit map index as the message suggests?

ERROR at line 1:

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

Trying to use the keyword local in front leads to wrong syntax.

Thanks in advance !!
Somnath

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 10 2004

Added on Oct 12 2004

#general-database-discussions

3 comments

5,257 views