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

Home -> Community -> Usenet -> c.d.o.server -> Re: Very strange problem.

Re: Very strange problem.

From: Scarab <yw_at_lucent.com>
Date: Wed, 28 Dec 2005 14:53:18 +0800
Message-ID: <dotcoh$end@netnews.net.lucent.com>


Giridhar,
My Oracle is 8.1.7, I delete records according to rowid, It work for me. I recall your case is also possible, I have ever seen such a case, but the error message is not : snapshot too old error, but others which I can't remember.

Thanks

"Giridhar" <gkodakalla_at_gmail.com> wrote in message news:1135747171.889177.308550_at_o13g a 2000cwo.googlegroups.com...
> Hi,
> I have a doubt whether we can have a cursor on the table and open the
> cursor to delete data
> from the same table. Will it not cause "snapshot too old error" (1555
> Error)?
>
> Thanks,
> Giridhar Kodakalla
>
Received on Wed Dec 28 2005 - 00:53:18 CST

Original text of this message

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