Hai all,

I tried to resize a datafile which was in autoextend mode.The file size is 2.5gb where as the contents of the file is only up to 1gb.So I tried to resize it to 1.5gb but I'm getting the error,
ORA-03297: file contains used data beyond requested RESIZE value

I tried to alter tablespace coalesce and then checked outwith dba_free_space.To my surprise there is no much change in the bytes and blocks of dba_free_space or dba_free_space_coalesced after coalescing.

Kindly let me know the possibilities of resizing my datafile.

regards,
Niranjan.