ORA-01652: unable to extend temp segment by 128 in tablespace TEMP

解决办法  --创建中转临时表空间   2.create  temporary   tablespace  TEMP02  TEMPFILE  '/u01/app/oracle/oradata/perm/temp02.dbf'  SIZE 1024M  REUSE  AUTOEXTEND  ON  NEXT  640K  MAXSIZE  UNLIMITED;  --改变缺省临时表空间   为刚刚创建的新临时表空间temp02  3.alter  database  default  temporary  tablespace  temp02; --删除原来临时表空间 4.drop  tablespace  temp01  including  contents  and   datafiles;--重新创建临时表空间 5.create  temporary  tablespace  TEMP  TEMPFILE   '/u01/app/oracle/oradata/perm/temp01.dbf'  SIZE 1024M  REUSE  AUTOEXTEND  ON   NEXT  640K  MAXSIZE  UNLIMITED;     --重置缺省临时表空间为新建的temp表空间 6.alter  database   default  temporary  tablespace  temp01; --删除中转用临时表空间   7.drop   tablespace  temp02  including  contents  and  datafiles;--重新指定用户表空间为重建的临时表空间  8.alter  user sys  temporary  tablespace  temp;