Re: Trouble with my first bitmap join index

From: Randolf Geist <>
Date: Fri, 17 Jul 2009 05:36:22 -0700 (PDT)
Message-ID: <>

On Jul 16, 10:01 pm, AIM <> wrote:
> Oracle 10gR1 seems perhaps not to allow
> BITMAP join INDEXES one partitioned tables.
> Everytime I tried creating an bitmap join index
> in any combination I recieved the following
> error.
> ORA-25122: Only LOCAL bitmap indexes are permitted on partitioned
> tables

And did you try to add the LOCAL keyword to the CREATE INDEX command?


Oracle related stuff blog:

SQLTools++ for Oracle (Open source Oracle GUI for Windows): Received on Fri Jul 17 2009 - 07:36:22 CDT

Original text of this message