How to resize a tempfile?

In Oracle 8i/9i/9.2/10g - how to resize a tempfile if a sort segment has grown too big?
If I try to use

alter database tempfile '/u01/oradata/PROD/temp01.dbf' resize 1000m;

it produces ORA-03297: file contains used data beyond requested RESIZE value

So is the any way to drop/resize/"re-initialize" sort segment?

Thanks Received on Mon Mar 07 2005 - 01:26:18 CST