Re: Trouble with my first bitmap join index

From: Randolf Geist <mahrah_at_web.de>
Date: Fri, 17 Jul 2009 05:36:22 -0700 (PDT)
Message-ID: <841a42a3-b08e-480d-94e0-7e47c2d6bc94_at_a7g2000yqk.googlegroups.com>



On Jul 16, 10:01 pm, AIM <Andre_Miku..._at_Hotmail.com> 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?

Regards,
Randolf

Oracle related stuff blog:
http://oracle-randolf.blogspot.com/

SQLTools++ for Oracle (Open source Oracle GUI for Windows): http://www.sqltools-plusplus.org:7676/
http://sourceforge.net/projects/sqlt-pp/ Received on Fri Jul 17 2009 - 07:36:22 CDT

Original text of this message