Re: Ora 04020 - deadlock detected while trying to lock object

From: <karsten_schmidt8891_at_my-deja.com>
Date: Tue, 26 Oct 1999 11:42:14 GMT
Message-ID: <7v442m$rg3$1@nnrp1.deja.com>

Hi,

Any other statements in the insert-transaction ? perhaps you locked another object in the same transaction and somebody else is doing it the other way round ?
Is someboy doing ddl at the same time ?

Karsten

In article <3814cbb0_at_news.lhsgroup.com>, "Alan Formstone" <aformstone_at_us.lhsgroup.com> wrote:
>
> Thomas Kyte wrote in message ...
> >
> >are you using declaritive integrity? do you have your foreign keys
> indexed?
> >See the URL in my signature for a short paper "Unindexed Foreign
Keys --
> why
> >they might be bad and how to detect them"
>
> >See http://osi.oracle.com/~tkyte/ for my columns 'Digging-in to
> Oracle8i'...
> >Current article is "Part I of V, Autonomous Transactions" updated
June
> 21'st
> >
> >
>
> All the foriegn Keys are indexed, a point i didn't mention earlier is
that
> the failing statement is an insert.
> Also there are no triggers on this table.
>
> Thanks,
> Alan
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Oct 26 1999 - 06:42:14 CDT