Sybrand Bakker wrote:
> 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
currently, during the delete the operation - the undo fills up the disk.
any other suggestions, if this isn't ideal? i can't think of any
myself... thanks.
Received on Wed Jun 21 2006 - 09:02:38 CDT
