create table tablename
as
select * for table2

我收到错误

ORA-01652 Unable to extend temp segment by in tablespace

当我googled我通常发现ORA-01652错误显示一些值

Unable to extend temp segment by 32 in tablespace

我没有得到任何这样的价值.我运行这个查询

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" 
from 
   (select 
      tablespace_name,round(sum(bytes) / 1048576) TotalSpace 
   from 
      dba_data_files 
   group by 
      tablespace_name 
   ) df,(select 
      tablespace_name,round(sum(bytes) / 1048576) FreeSpace 
   from 
      dba_free_space 
   group by 
      tablespace_name 
   ) fs 
where 
   df.tablespace_name = fs.tablespace_name;

取自：Find out free space on tablespace

我发现我目前使用的tablespace具有大约32Gb的可用空间.我甚至尝试创建表

create table tablename tablespace tablespacename
as select * from table2

但我再次收到相同的错误.任何人都可以给我一个想法,问题在哪里,如何解决.对于您的信息,select语句将获取40,000,000条记录.