数据库报错， 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表空间的使用