oracle10g - ORA-01652 Unable to extend temp segment by in tablespace -

i creating table like

create table tablename select * table2 

i getting error

ora-01652 unable extend temp segment in tablespace 

when googled found ora-01652 error showing value like

unable extend temp segment 32 in tablespace 

i not getting such value.i ran query

select     fs.tablespace_name                          "tablespace",     (df.totalspace - fs.freespace)              "used mb",     fs.freespace                                "free mb",     df.totalspace                               "total mb",     round(100 * (fs.freespace / df.totalspace)) "pct. free"      (select        tablespace_name,        round(sum(bytes) / 1048576) totalspace            dba_data_files     group        tablespace_name     ) df,     (select        tablespace_name,        round(sum(bytes) / 1048576) freespace            dba_free_space     group        tablespace_name     ) fs      df.tablespace_name = fs.tablespace_name;  

taken from: find out free space on tablespace

and found tablespace using has around 32gb of free space. tried creating table like

create table tablename tablespace tablespacename select * table2  

but getting same error again. can give me idea, problem , how solve it. information select statement fetch me 40,000,000 records.

i found solution this. there temporary tablespace called temp used internally database operations distinct, joins,etc. since query(which has 4 joins) fetches 50 million records temp tablespace not have space occupy data. hence query fails though tablespace has free space.so, after increasing size of temp tablespace issue resolved. hope helps same issue. :)