Re: 'Deleting' rollback segment ? - how

From: janek_at_raycom-systems.demon.co.uk (Jan Kucharski) >> How can I 'delete' a system rollback segment which has become 50Mb ? Or  recreate it to be 5Mb <<

I do not think you can or want to delete the system rollback segment. Try to  give it an optimal size of 5M and use the 'alter rollback segment_name  shrink;' command. Make sure your system has non-system rollback segments for  application use.

Mark Powell -- The only advise that counts is the advise that you follow so follow your own advise Received on Fri Oct 31 1997 - 00:00:00 CST