Re: Partition exchange, bitmap join indexes and ORA-14098

<schonlinner_at_yahoo.com> wrote in message news:1121241104.280411.253990_at_z14g2000cwz.googlegroups.com...
> Hi,
>
> I wanted to use the partition exchange feature from Oracle in order
> to update a production warehouse on a monthly basis.
>
> Now I came across a problem which I cannot resolve (either it's
> due to me or due to a bug in Oracle).
>
> In short: I cannot perform an "alter table exchange partition" whenever
> there are more than 1 bitmap join indexes on the tables (ORA-14098:
> index mismatch for tables in ALTER TABLE EXCHANGE PARTITION) . A single
> bitmap join index ==> it works.
>
> It's not due to the index definition: If I drop either of the two (on
> both tables, of course), so I have only a single bitmap join index on
> each of the two tables, it works. I can even have any number of
> "normal" (bitmap, B*Tree) indexes on both of the tables, but only a
> single bitmap join index :-((
>
> Am I missing something? Is this by design? Or a bug?
>
> Best regards,
> Alex
>

Bug number 4421063
Present still in 9.2.0.6 and 10.1.0.4

-- 
Regards

Jonathan Lewis

Now waiting on the publishers:    Cost Based Oracle - Volume 1

http://www.jlcomp.demon.co.uk/faq/ind_faq.html
The Co-operative Oracle Users' FAQ

http://www.jlcomp.demon.co.uk/appearances.html
Public Appearances - schedule updated 8th July 2005