Re: large delete

On Tue, 20 Jun 2006 16:21:27 -0700, Akimeu <Nospam_at_Email.com> wrote:

>hello,
>
>i have done some looking around for this, but haven't really found a
>solid answer. we have an sp, to which we're passing in a table name,
>after which we execute immediate a delete statement. is there any way
>of committing within this particular delete?
>
>any insights/suggestions are appreciated. thanks.
>
>this is what i was thinking of doing:
>
> loop
> vsql:='delete from '||vschem||'.'||vtablename||
> ' where '||vcol||'='''||vid||''' and rownum <= 10000';
> execute immediate vsql;
> exit when sql%rowcount = 0;
> commit;
> end loop;

do NOT commit every n records. You will be hitting 'snapshot too old' because of this.

--
Sybrand Bakker, Senior Oracle DBA