Re: Rollback Segment Errors
Date: Fri, 27 Jun 2003 13:38:09 GMT
Message-ID: <5NXKa.32741$Ab2.59476_at_sccrnsc01>
Varol,
Thanks very much...I'll talk to DBA about using a bigger segment with
SET TRANS...
Thanks again
Tomas
"varol cavdar" <varol_at_bilisim-ltd.com.tr> wrote in message
news:e014aa93.0306270348.6f893ae9_at_posting.google.com...
> Hi Tomas
> The only way to delete table records without using a rollback
> segment is to use truncate command. In this case all records in your
> table will be deleted and committed implicitly.
>
> Another method is to select a bigger rollback segment. To do this
> you should use "SET TRANSACTION USE ROLLBACK SEGMENT rbig;" command at
> the begining of your transaction. If rbig is big enough then you can
> delete much more records at a time
>
> best regards..
Received on Fri Jun 27 2003 - 15:38:09 CEST