Re: Oracle deadlock on table with indexes.

From: Paul <paulz_at_cavendish.co.uk>
Date: 21 Jul 2004 03:43:51 -0700
Message-ID: <a4ca837.0407210243.c75eab0@posting.google.com>

The index was actually set by someone other than myself on a different site.
When I comapred the indexes given VC's message, I noted that on one index they had set a bitmap. I changed this to a bog-standard index (non-unque in my case) and the deadlock dissapeared.

Hope this helps!
Paul

"Volker Hetzer" <volker.hetzer_at_ieee.org> wrote in message news:<cdjn40$2vk$1_at_nntp.fujitsu-siemens.com>...
> "Paul" <paulz_at_cavendish.co.uk> schrieb im Newsbeitrag news:a4ca837.0407200231.6339f49c_at_posting.google.com...
> > Many thanks VC!
> > Works a treat now.
> So, what did you do? Don't you use bitmap indexes any more?
>
> Lots of Greetings!
> Volker
Received on Wed Jul 21 2004 - 05:43:51 CDT