Re: Oracle rollback segment

From: Robert Yeh <robert.yeh_at_qwest.com>
Date: Tue, 5 Jun 2001 09:27:36 -0400
Message-ID: <9fimgj$2b7$1@bob.news.rcn.net>

Why can't you do "delete from your_table where your_condition and rownum < 5001"?

Keep doing this until all the rows that meet your_condition are deleted.

Anshumn wrote in message
<375b211e.0106020142.1b1ec387_at_posting.google.com>...
>Hi,
>
>Need some input regarding Oracle Rollback Segment.
>
>Due to the Rollback segment size restriction, the deletion of the
>records is failing. Now one way to solve this is to increase the size
>of
>the rollback segment.
>The other way is to use 'TRUNCATE' to delete the records. But in my
>case, I want to delete specific records based on the specified
>condition. So can some condition be used with the TRUNCATE clause? I
>checked it up, it is not allowing...any other way to do it ?
>
>If I don't increase the size of the segment, then I want to delete
>records and do an intermediate commit after every 5000 records. Any
>suggestions how to do it ?
>
>Also please let me know how to increase the size of the rollback
>segment.(This is the last option)
>
>Regards,
>Anshumn
Received on Tue Jun 05 2001 - 08:27:36 CDT