Re: Rollback Segment Errors
From: varol cavdar <varol_at_bilisim-ltd.com.tr>
Date: 27 Jun 2003 04:48:07 -0700
Message-ID: <e014aa93.0306270348.6f893ae9_at_posting.google.com>
Date: 27 Jun 2003 04:48:07 -0700
Message-ID: <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 - 13:48:07 CEST