Hello All,

I'm using LMT.

I've droppped a few large tables and released 3GB of space. This is seen in the TABLESPACE option of OEM, where it is saying 94% used. When I'm looking into datafiles its showing a lot of bytes free. Now when I try to resize the datafiles its throwing the error:

ORA-03297: file contains used data beyond requested RESIZE value

And I've gone thru ASKTOM's article and tried the the "maxshrink.sql" but it is also showing 'Poss. Savings = 0" for all the 4 datafiles of that tablespace.

I've tried ALTER TABLESPACE .. COALESCE , but the result is same.

I've time and space constraints so I cannot do an EXP & IMP to release space.

Please help me to solve the problem.

Thanks,
Ano