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?