Re: Insert into with nowait?

"Stewart Burnett" <Stewart_at_burnettms.nospam.demon.co.uk> wrote:

>But consider - if you are inserting a new record how can another user =
have
>locked it before you inserted it?

Hi Stewart,

this can happen if two users are trying to insert records with the same primary key or unique key value - the first user will have a lock on the index block, so the second will have to wait until the first one either does a commit or rollback. In the first case, user #2 gets an error about the key violation, in the second case the insert succeeds.

HTH
Peter

--
Peter Schneider
pschneider_at_knuut.de Received on Fri Nov 06 1998 - 16:47:11 CST