Resize Datafile in Oracle.

*** Select DATAFILE

select c.name from v$tablespace a, v$datafile b, v$dbfile c where a.TS# = b.TS# and b.FILE# = c.FILE# and a.NAME= 'SYSTEM';

NAME
--------------------------------------------------------------------------------
+DATA1/tatshuya/datafile/system.258.616675057

*** use the result upper

alter database datafile '+DATA1/tatshuya/datafile/system.258.616675057' resize 1G;

-- TaTsHuYa --