Re: Help! failed to extend rollback segment error.

In article <49efai$rpf_at_fountain.mindlink.net>,

   David Ng <David_Ng_at_mindlink.bc.ca> wrote:
>Hi,
>
>Try set the optimal size of the rollback segment. (That make the
>rollback segment will shrink back to a pre-defined size). SQL
>statement will be like
>
>Alter table A default storage(initial 500K next 500K optimal 1M)
>
>
>>
>>
>> Hi ,
>>
>> My rollback segments are keep growing, is there a way to cleanup the
>> rollback segments savely?
>>
>> Thanks!.
>>
>>
>
>
You could also regularly drop and re-create your rollback-segments. This is the only way to manually clean up your rollback-segments and it works fine with my databases.

Regards,
Rene.

| Rene Hoekstra
| E-Mail : Rene.Hoekstra_at_rivm.nl
| National Institute of Public Health and Environmental
| Protection (R.I.V.M.)
| Bilthoven, The Netherlands
============================================================
      " Alleen slaapwandelaars kunnen in slaap vallen "
============================================================