Allocate unlimited extents for a database object

[sasa888]

Hi all, anybody see any negative impact on setting the value of the maxextents storage parameter to UNLIMITED? Once I set it, can I undo it?

Thanks,
ss

 

[karluk]

The obvious problem is that a single runaway insert can fill up your entire tablespace. In compensation you gain assurance that a legitimate insert won't fail because of undetected space problems.

 

[sasa888]

Thanks, Karluk... if I am to alter the rollback segment storage, I know that I have to bring the rollback segment offline and alter the rollback segment, during the course of this action, is it true that there should be no database transaction while the rollback segment is being changed?
Thank you so much.

Elsa

 

[karluk]

You won't be able to take a rollback segment offline while it is being used by another transaction. However, if another transaction is running in a different rollback segment, there should be no impact.

I expect that if you try to take the rollback segment offline while someone else is using it, your alter will simply wait until the other transaction is finished. I would just wait for a quiet period before doing the alters.