Hi all,

In my ProductionDB i have truncated table which contails 4.7GB.The table present in ISHDATA tablespace with datafiles
'/mnt/db/oracle/oradata/ISPRO/ishdata01.dbf' upto 10 files are there in Ishdata tablespace.

After truncating i tried to resize all the 10 datafiles, to show free space at OS level.(MD wants to see at OS level.)

So i tried as ..
SQL> alter database datafile '/mnt/db/oracle/oradata/ISPRO20/ishdata01.dbf' resize 1900m;
alter database datafile '/mnt/db/oracle/oradata/ISPRO20/ishdata01.dbf' resize 1900m
*
ERROR at line 1:
ORA-03297: file contains used data beyond requested RESIZE value
...

SQL> alter database datafile '/mnt/db/oracle/oradata/ISPRO20/ishdata10.dbf' resize 4000m;
alter database datafile '/mnt/db/oracle/oradata/ISPRO20/ishdata10.dbf' resize 4000m
*
ERROR at line 1:
ORA-03297: file contains used data beyond requested RESIZE value

spaces at datafiles reduces at different level ie., for one datafile 250MB released another 1800MB released.

So,please help me on this regard.

Thanks in advance.