oracle 数据表空间问题

　　oracle中的alert_orcl.log提示信息如下：
　　ORA-1652: unable to extend temp segment by 128 in tablespace                 TEMP
　　Thu May 27 05:00:23 2010
　　ORA-1652: unable to extend temp segment by 128 in tablespace                 TEMP
　　Thu May 27 06:00:24 2010
　　ORA-1652: unable to extend temp segment by 128 in tablespace                 TEMP
　　Thu May 27 06:30:19 2010
　　Private_strands 3 at log switch
　　Thread 1 advanced to log sequence 13249
　　Current log# 3 seq# 13249 mem# 0: /Data1/orcl/redo03.log
　　Thu May 27 07:00:25 2010
　　ORA-1652: unable to extend temp segment by 128 in tablespace                 TEMP
　　ORA-1652: unable to extend temp segment by 128 in tablespace                 TEMP
　　Thu May 27 09:00:28 2010
　　ORA-1652: unable to extend temp segment by 128 in tablespace                 TEMP
　　orcl_j000_17773.trc中的提示信息：
　　*** SERVICE NAME:(SYS$USERS) 2010-05-26 08:52:52.137

　　*** SESSION>　　Before in kgllkdl(), hd=80e80840.
　　Before in kgllkdl(), hd=80e97e38.
　　Before in kgllkdl(), hd=7ffc2680.
　　Before in kgllkdl(), hd=7ff640a8.
　　Before in kgllkdl(), hd=7ffba480.
　　Before in kgllkdl(), hd=80ecf140.
　　Before in kgllkdl(), hd=801fc8a0.
　　Before in kgllkdl(), hd=80f70800.
　　Before in kgllkdl(), hd=80ecf140.
　　Before in kgllkdl(), hd=80eaa8a0.
　　Before in kgllkdl(), hd=813e0b08.
　　Before in kgllkdl(), hd=813d6798.
　　Before in kgllkdl(), hd=80f4de90.
　　Before in kgllkdl(), hd=813e0b08.
　　Before in kgllkdl(), hd=813d6798.
　　Before in kgllkdl(), hd=80f70800.
　　Before in kgllkdl(), hd=80ecf140.
　　Before in kgllkdl(), hd=80eaa8a0.
　　Before in kgllkdl(), hd=80f4de90.
　　Before in kgllkdl(), hd=813f0190.
　　Before in kgllkdl(), hd=813d6798.
　　Before in kgllkdl(), hd=813da7f0.
　　Before in kgllkdl(), hd=80f70800.
　　Before in kgllkdl(), hd=80ecf140.
　　Before in kgllkdl(), hd=80f4de90.
　　Before in kgllkdl(), hd=813e0b08.
　　Before in kgllkdl(), hd=813d6798.
　　Before in kgllkdl(), hd=813da7f0.
　　Before in kgllkdl(), hd=80f70800.
　　Before in kgllkdl(), hd=80ecf140.
　　Before in kgllkdl(), hd=80eaa8a0.
　　Before in kgllkdl(), hd=80f4de90.
　　Before in kgllkdl(), hd=813d6798.
　　Before in kgllkdl(), hd=813da7f0.
　　Before in kgllkdl(), hd=80f70800.
　　Before in kgllkdl(), hd=80ecf140.
　　Before in kgllkdl(), hd=80eaa8a0.
　　Before in kgllkdl(), hd=80f4de90.
　　Before in kgllkdl(), hd=813d6798.
　　Before in kgllkdl(), hd=813da7f0.
　　Before in kgllkdl(), hd=80e73570.
　　Before in kgllkdl(), hd=7ff574c8.
　　Before in kgllkdl(), hd=80e73570.
　　解决：
　　发现临时表空间temp的数据文件已经丢失，通过重新创建临时表空间即可。
1.startup --启动数据库2.create temporary tablespace TEMP2 TEMPFILE ''/home2/oracle/oradata/sysmon/temp02.dbf''>3.alter database default temporary tablespace temp2;--改变缺省临时表空间 为刚刚创建的新临时表空间temp24.drop tablespace temp including contents and datafiles;--删除原来临时表空间5.create temporary tablespace TEMP TEMPFILE ''/home2/oracle/oradata/sysmon/temp01.dbf''>6.alter database default temporary tablespace temp;--重置缺省临时表空间为新建的temp表空间7.drop tablespace temp2 including contents and datafiles;--删除中转用临时表空间8.alter user roll temporary tablespace temp; --重新指定用户表空间为重建的临时表空间　　也可以通过em图形界面来操作。