Hi -

I'm trying to reduce the size of the rollback segment tablespace datafile in a test db from 1GB to 500M (using 'alter database datafile 'filename' resize 500M'), but I get the 'file contains xxx blocks of data beyond the requested RESIZE value' error. This is confusing since the total space used by my online rollback segments is less than 10MB. Any ideas?

I'm running 8.0.6 on HPUX 11.0.

Thanks -

Tim