Moving tables to new tablespace needs temp space or any kind of addictional space? (Oracle 11g)
Moving a table does not use the temporary tablespace.

SQL&gt; show parameter target

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
archive_lag_target                   integer     0
db_flashback_retention_target        integer     1440
fast_start_io_target                 integer     0
fast_start_mttr_target               integer     0
memory_max_target                    big integer 0
memory_target                        big integer 0
parallel_servers_target              integer     64
pga_aggregate_target                 big integer 256M
sga_target                           big integer 1G

SQL&gt; select bytes/1024/1024 as bytes_mb, tablespace_name from user_segments where segment_name = 'SALES2';

  BYTES_MB TABLESPACE_NAME
---------- ------------------------------
      2240 EXAMPLE2

SQL&gt; select file_id from dba_temp_files;

   FILE_ID
----------
         1

SQL&gt; alter database tempfile 1 drop;

Database altered.

SQL&gt; select file_id from dba_temp_files;

no rows selected

SQL&gt; select sys_context('userenv', 'sid') from dual;

SYS_CONTEXT('USERENV','SID')
--------------------------------------------------------------------------------
191

SQL&gt; select serial# from v$session where sid = 191;

   SERIAL#
----------
       415

SQL&gt; alter table sales2 move tablespace example3;

Table altered.

SQL&gt; select bytes/1024/1024 as bytes_mb, tablespace_name from user_segments where segment_name = 'SALES2';

  BYTES_MB TABLESPACE_NAME
---------- ------------------------------
      2240 EXAMPLE3

SQL&gt; select max(temp_space_allocated), count(*) from v$active_session_history where session_id = 191 and session_serial# = 415;

MAX(TEMP_SPACE_ALLOCATED)   COUNT(*)
------------------------- ----------
                        0         33