Try these two commands.
First find out the the active number of extents in each rollback segment and shrink the rollback segments
1. Alter Rollback segment r1 shrink to nn m;
After shrinking the rollback segments like this,
2. Alter database datafile 'rbs.dbf' resize 1024M;




Reply With Quote