I have problem with decreasing size of datafile. It was filled up to 96 % so I moved largerest tables to another tablespace, but datafile for original tablespace did not reduce it's allocated space. If i had tried 'ALTER DATABASE DATAFILE /.../filename RESIZE xxx M' it allowed me reduce only a few space. I thing it is because of internal fragmentation in the tablespace. How to make the datafile become smaller.
I cannot create new datafile with new tablespace, move all tables to new tablespace and drop original datafile, because database in archivelog mode and I cannot change it.
thanks for help.