Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Insert into with nowait?
Not a lock error is the problem, a primariy index error could happens.
E.g. The primary key of one table is generated via a function (select count(*) from Table) so that you get the next number. But if two do that at the same time you may get an index error (very late/slowly). I cannot use sequences because I cannot accept wholes in the series.
Kind regards
Nicolas Bronke
Stewart Burnett schrieb in Nachricht <71v6l1$u99$1_at_hagen.cloud9.co.uk>...
>In short NO.
>
>But consider - if you are inserting a new record how can another user have
>locked it before you inserted it?
>
Received on Fri Nov 06 1998 - 13:21:10 CST