Hi All, I am trying to reclaim the space from datafiles after dropping the partitions from tables. I see from Oracle enterprise manager tablespace map/extent map that there is plenty of disk space(about 75%) that can be reclaimed, I have tried the following methods so far, but no luck. if anyone has ideas(other than export/import or move to new tablespace methods), please share.
Methods
************
1. Moved all the objects in the tablespace to the same tablespace (As there was not enough disk space to create a new tablespace)
2. shrink space on tables, lobs, indexes and datafiles
Version of Oracle is 12R2
Thanks