Reclaim Unused Space - alter table move, shrink, or expdp/impdp
CACHE
CLUSTER
INDEX
INDEX PARTITION
INDEX SUBPARTITION
LOB PARTITION
LOBINDEX
LOBSEGMENT
NESTED TABLE
TABLE
TABLE PARTITION
TABLE SUBPARTITION
If I want to reclaim all the unused spaces, which one of the following is a better option:
1) alter table move to move all the objects from TABLESPACE_1 to TABLESPACE_2
drop TABLESPACE_1
rename TABLESPACE_2 to TABLESPACE_1
2) alter table shrink