How to set Rollback segments grow automatically?(m45)


Is there a way to make rollback segments/tablespaces grow automatically?


Ans:

Having no idea of what version you are running it's a kind of risky. But you
could set AUTOEXTEND ON for the files involved IF YOU ARE SURE you don't
fill up your file system and if maxextents is unlimited.
BUT I warn to do that, it's not the clean thing. Rollback should be sized
diligently. Ever had a "runaway" procedure inserting unlimited numbers of
rows? ;-((

Regards Eike
 

Hosted by www.Geocities.ws

1