----------------------------------------------------------
-- Description: resize a datafile
-- 
-- Author: David Clement
-- Modifications: 27-APR-2006 Created 
-----------------------------------------------------------

select df.file#, df.name, df.bytes/1024/1024
from v$datafile df,
v$tablespace ts
where df.ts#=ts.ts#
and ts.name='&1'
/

alter database datafile '&2'
resize &3
/