Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: delete rows with LONG RAW
You probably aren't going to like this much. IF you can clear
the whole table use
the TRUNCATE TABLE TABa rather than delete. This is FAST
and uses next best thing to zero rollback. If you must do only
a few rows
then you will need a VERY large rollback segment. Creat a new
one, take existing ones
off line, put the new one on line, do the delete with as
few rows at once as possible. COMMIT FREQUENTLY! then when
you are done, take the big rollback segment offline and put
the regular ones back online. You can then drop the big
rollback segment if you don't expect
to do this again soon.
Good Luck
Becca
> 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
>
>
>
>
>
--
This answer is courtesy of QuestionExchange.com
http://www.questionexchange.com/showUsenetGuest.jhtml?ans_id=4478&cus_id=USENET&qtn_id=3652
Received on Mon Oct 11 1999 - 08:04:16 CDT