Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Help!! Insert taking a very long time??

Re: Help!! Insert taking a very long time??

From: Roger Wernersson <roger.wernersson_at_adra.se>
Date: 1996/12/13
Message-ID: <32B12E8D.354F@adra.se>#1/1

Z. Martinez wrote:
> I'm having a bit of a problem in an INSERT command in SQL*PLUS.
> The SQL command goes something like this:
>
> INSERT INTO accounts (account_id)
> VALUES ('W11111');
Hi Z! I don't know much about this but when I checked, no-one else had answered. This could be due to a row lock. If a row with this value already exists and is locked by another session your session will be locked waiting for it's release, but I am not 100% sure.

-- 
Sport radio: people listening to people watching people having fun
Mailto:roger.wernersson_at_adra.se
BTW: All opinions are mine, all mine, and nobody's but mine.
Received on Fri Dec 13 1996 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US