Re: Can't delete 60000 records at a time

Try

truncate table xyz;

or

alter rollback segment ??? storage (next xxx M);

with ??? : the name of one of your rollback segments and xxx : select bytes from dba_segments where segment_name = 'your_table';

set transaction use rollback segment ???;

delete your_table;

Hope this helps

Oliver

On Tue, 19 May 1998 12:30:25 -0500,
 alex_at_webis.net (Alex Kac) wrote:

> I have a database where I need to delete only 60,000 records at once, but
> I keep on getting an error like:
>
> ERROR at line 1:
> ORA-01562 failed to extend rollback segment number 6
> ORA-01628 max # of extents (121) reached for rollback segment RB5
>
> I've looked in the manual and have done the procedures it talked about but
> I still can't get the extents above 121, or the unlimited_extents flag to
> true. I can delete the database in small segments, but at the point I am
> deleting the last 20000, I have to actually restart the whole machine to
> delete that last bit piece by piece...i.e. it won't let me even delete
> 1000 records.
>
> Any ideas would be very helpful!
>
> I lurk in this newsgroup a few times a week, so an email followup would be
> appreciated: alex_at_webis.net
Received on Tue May 19 1998 - 00:00:00 CDT