I need space on my disk, and i have a datafile that takes 6 gig. it contain only 3gig of data.
I want to resize and it gives me:
ORA-03297: file contains used data beyond requested RESIZE value

I did an alter table move tablespace

On all my table in the same tablespace.
I did a rebuild on all my index.

NOTE: I CANT DO A EXPORT/IMPORT because 24/24 database.


1. What oracle table or view can tell me wich object is beyond resize value?

2. I have also package, sequence, function and procedure, do i have to recreate them?