ORA-03214: File Size specified is smaller than minimum required
650105May 15 2009 — edited May 15 2009i'm working with 11g on windows 2003 server. i often issue this statement
alter tablespace temp shrink space
this command run successfully and if we have 5 tempfile in temp tablespace. 4 temfile shrink successfully but one always remain as it my question why this happen? All tempfile should be shrink.
when i tried to shrink that temfile seperatly by issuing it give me error ORA-03214: File Size specified is smaller than minimum required
SQL> ALTER TABLESPACE TEMP SHRINK TEMPFILE 'E:\app\administrator\oradata\ORCL\DA
TAFILE\TEMP02.DBF';
ALTER TABLESPACE TEMP SHRINK TEMPFILE 'E:\app\administrator\oradata\ORCL\DATAFIL
E\TEMP02.DBF'
*
ERROR at line 1:
ORA-03214: File Size specified is smaller than minimum required