resize datafiles after moving tablespace objects
I'm not able to resize datafiles of a tablespace
as in the tablespace there is a lot of free space I would to disallocate it
so I moved all objects in the tablespace (table, table partition, lobsegment, lob partition) and a I rebuild all indexes and index partitions located in the tablespace
At the end I only could do some very small resize (I have more than 1T of free space and I was able to recover few GBs)
isn't enough moving objects to recover free space ?