解决办法 --创建中转临时表空间 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;
本文出自 “O Record” 博客，请务必保留此出处http://evils798.blog.51cto.com/8983296/1420898
ORA-01652: unable to extend temp segment by 128 in tablespace TEMP,布布扣,bubuko.com
ORA-01652: unable to extend temp segment by 128 in tablespace TEMP
原文：http://evils798.blog.51cto.com/8983296/1420898