Hi,
DB - 12.1.0.2.0
OS - Oracle Linux Server 6.10
We having Big File Tablespace where only datafile and size of the datafile is around 4TB. Now management ask us to do the fragmentation/re-org.
What is the best method to do and how much time it will take for the same ?
1. alter table ... move + rebuilding indexes
2. create table as select.
3. export / truncate / import
4. Shrinking the Table.
Thank You.