It does, but u need to plan correctly before creating any Tablespace or so...
i guess u might have spcified UNLIMITED option for the datafile with autoextend ON....and moreover rollback segment is more prone to fragmentation....and collace will not work in such cases...u also need to be use the parmeters correctly while creation of rollback segments....
Abhay.
funky...
"I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."
"Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"
Reply With Quote