Originally posted by Anomitro
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
If you don't have the space, then you are stuck. Did someone ask you to do this online?