DB version : 11.2.0.4
OS : RHEL 6.5
Lets say I have tablespace which is 100GB in size [ sum(dba_Data_files.bytes) = 100 GB ]
And I only have one table in this tablespace which is 70GB in size. How much free space in the tablepsace do I need to run the below command ?
alter table ORDER_DTL move;
Reason why I am asking this:
In production , I have a table which is 2.6 TB in size. In production's clone environment, I ran the following SHRINK command and it took 4 days to complete !!
alter table ORDER_DTL shrink space cascade;
Since SHRINK is taking very long, I thought of testing MOVE command as an alternative. But, the MOVE command errored out with the following message after 1 hour and 47 minutes.
SQL> alter table ORDER_DTL move;
ERROR at line 1:
ORA-01652: unable to extend temp segment by 8192 in tablespace ORDER_DTL_DATA
Elapsed: 01:47:23.25
ORDER_DTL_DATA tablespace is used only for ORDER_DTL table. It is 3.5 TB in size [ sum(dba_Data_files.bytes) = 3.5 TB ]
and 2.6 TB is utilized and ORDER_DTL_DATA tablespace only has 900 GB free.
So, if I want run MOVE command on ORDER_DTL table, which is 2.6 TB in size, do I need to have at least 2.6 TB (or more) free space in its tablespace ?