Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Oracle error 1555 snapshot too old
Hi,
I try to delete about 1 000 000 rows in my table with the following command
CURSOR Cur_DeleteAll IS
SELECT ROWID FROM ITEM WHERE (ITEMCODE, CODE, INSERTTIME,
RECORDTYPE) IN
(SELECT ITEMCODE, CODE, INSERTTIME, RECORDTYPE FROM
TMPSPEITEMDEL);
OPEN Cur_DeleteAll;
LOOP
FETCH Cur_DeleteAll INTO vRowId; EXIT WHEN Cur_DeleteAll%NOTFOUND; DELETE FROM ITEM WHERE ROWID = vRowId; Cpt_Commit := Cpt_Commit + 1; Cpt_LigEfface := Cpt_LigEfface + 1; IF Cpt_Commit = 1000 THEN Commit; Cpt_Commit := 0 END IF;
Does anybody explain me why this message appears ? I commit my transaction every 1000 rows. I don't understand what's happening.
Thanx Received on Mon Dec 06 1999 - 04:04:11 CST