~~~~~~~~~高分~~~oracle 临时表空间问题~~~~~~~~~~~~！
数据库报错，   ora-01652   无法通过128（在表空间temp中）扩展temp字段。这是我的表空间的信息

1 SYSTEM 8192 65536 1 2147483645 65536 ONLINE PERMANENT LOGGING NO LOCAL SYSTEM NO MANUAL
2 UNDOTBS1 8192 65536 1 2147483645 65536 ONLINE UNDO LOGGING NO LOCAL SYSTEM NO MANUAL
3 TEMP 8192 1048576 1048576 1 0 1048576 ONLINE TEMPORARY NOLOGGING NO LOCAL UNIFORM NO MANUAL
4 CWMLITE 8192 65536 1 2147483645 65536 ONLINE PERMANENT LOGGING NO LOCAL SYSTEM NO AUTO
5 DRSYS 8192 65536 1 2147483645 65536 ONLINE PERMANENT LOGGING NO LOCAL SYSTEM NO AUTO
6 EXAMPLE 8192 65536 1 2147483645 65536 ONLINE PERMANENT LOGGING NO LOCAL SYSTEM NO AUTO
7 INDX 8192 65536 1 2147483645 65536 ONLINE PERMANENT LOGGING NO LOCAL SYSTEM NO AUTO
8 ODM 8192 65536 1 2147483645 65536 ONLINE PERMANENT LOGGING NO LOCAL SYSTEM NO AUTO
9 TOOLS 8192 65536 1 2147483645 65536 ONLINE PERMANENT LOGGING NO LOCAL SYSTEM NO AUTO
10 USERS 8192 65536 1 2147483645 65536 ONLINE PERMANENT LOGGING NO LOCAL SYSTEM NO AUTO
11 XDB 8192 65536 1 2147483645 65536 ONLINE PERMANENT LOGGING NO LOCAL SYSTEM NO AUTO
12 PORTMGR 8192 65536 1 2147483645 65536 ONLINE PERMANENT LOGGING NO LOCAL SYSTEM NO AUTO


在网上搜索了很多文章，不知道怎么解决。求教，谢谢~~！！！

------解决方案--------------------
新建temp表空间temp2
再指定为默认temp表空间：

alter database default temporary tablespace temp2;


再drop旧的temp表空间即可

alter tablespace temp offline;

alter database tempfile '/paic/lbs/db1_8i/data/oradata/ld09gz/i3_orcl01.dbf ' offline drop;



------解决方案--------------------
检查你的查询语句，是不是进行了大量的排序等操作
适当优化查询才能减少temp表空间的使用