How to shrink RBS datafile

[raygg]

All my RBS are in one datafile. I am testing an app that requires long transactions that increase the rollbacks significantly and autoextend the rollback datafile to 2GB, then the RBS shrink back to 4M except for my large RB that shrinks back to 96MB. How to I shrink the datafile back to 130MB from 2GB? I am running 817 EE on NT workstation sp6.

 

[kindus]

You can shirnk the datafile upto the hisgest watermark, try this
Alter database datafile <filename> resize 500M;

thanks

 

[raygg]

Thank you. This is a big help.

Ray