Re: LOTS OF DATA, how do I delete it?
From: Chris Selwyn <chris_at_perihelion.co.uk>
Date: 1995/12/14
Message-ID: <4aosr6$mob_at_bell.ukonline.co.uk>#1/1
Date: 1995/12/14
Message-ID: <4aosr6$mob_at_bell.ukonline.co.uk>#1/1
Raymond Allo (rallo_at_world.net) wrote:
: rschick_at_eagle.wbm.ca (rschick) wrote:
: The other suggestion with stored procedure and a loop wiht a commit
: every 500 orso is not to bad either. It at least solves your rollback
: segment blow out.
Beware : with this solution you may get ORA-01555: Snapshot too old.
This is because it is not guaranteed that a cursor is maintained across a transaction boundary i.e. a commit. The way to avoid this is to remember where you last committed, close the cursor and re-open it at the point that you remembered.
-- Chris Selwyn Senior Consultant Perihelion Software email: chris_at_perihelion.co.uk tel: +44 1749 344203Received on Thu Dec 14 1995 - 00:00:00 CET