Topic: Oracle shrink space
Good afternoon! Already hundred times it was considered everywhere, but it would be desirable to hear the skilled. How all the same it is better/faster and more reliable in 12c to release a disk space?
1. alter table move + drop tablespace + rename tablespace
2. expdp + impdp
3. dbms_redefinition to move faster than in 1st point and in online
4. alter table shrink space cascade + alter database resize datafile