Re: delete rows with LONG RAW

You will need over 10 Mb of rollback for each row you want to delete since the whole row has to be copied into rollback.

I suggest you create a suitably large rollback segment and use 'set transaction use rollback segment ..' to delete a (very) few rows at a time.

Note: the redo log will get quite large at the same time.

--

Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk

Vadim Grepan wrote in message <7st646$suf$1_at_storm.comstar.ru>...
>Hello All!
>
> I need to delete some rows from table with LONG RAW field (each field
>keeps
> about 10Mb). I've tried somthing like DELETE tbl_data WHERE id=12343
> but 've got error message:
>
> ERROR at line 1:
> ORA-01562: failed to extend rollback segment number 2
> ORA-01650: unable to extend rollback segment R01 by 64 in
tablespace
>RBS
>
> Should I extend my rollback segments by hand (they are small enough) or
>there is
> better manner?
>
>Rgds, Vadim Grepan
>--------
>kezal_at_mail.ru
>2:5020/653_at_fidonet.org
>
>
>
Received on Wed Sep 29 1999 - 09:34:14 CDT