ORA-01652:unable to extend temp segment by num in tablespace name
来源:互联网 发布:英国君权级战列舰数据 编辑:程序博客网 时间:2024/05/30 04:17
今天在DataStage中出现这个错误:
F_APP_NB_L1,0: Oracle call failed; sqlcode = -1,652; message: ORA-01652: unable to extend temp segment by 128 in tablespace TEMP
此方面相关的知识,可看看: http://blog.csdn.net/lanmao100/archive/2010/07/13/5730979.aspx
出问题的SQL是这个:
select t.*
from F_APP_NB_L1 t
,(select a.appno ,a.classcode
,max(a.begtime) begtime
from F_APP_NB_L1 a
where a.endtime = '99991231999'
and exists (select *
from F_APP_NB_L1 b
where b.appno = a.appno
and b.classcode = a.classcode
and b.endtime < '99991231999')
group by a.appno,a.classcode) c
where c.appno = t.appno and c.classcode = t.classcode
and c.begtime = t.begtime ;
后改为:
with temp_nb as
(select a.appno ,a.classcode
,max(a.begtime) begtime
from F_APP_NB_L1 a
where a.endtime = '99991231999'
and exists (select *
from F_APP_NB_L1 b
where b.appno = a.appno
and b.classcode = a.classcode
and b.endtime < '99991231999')
group by a.appno,a.classcode)
select t.*
from F_APP_NB_L1 t
,temp_nb c
where c.appno = t.appno and c.classcode = t.classcode
and c.begtime = t.begtime
这样,etl就不报错了,同时速度快了很多。
- ORA-01652:unable to extend temp segment by num in tablespace name
- ORA-01652:unable to extend temp segment by num in tablespace name
- ORA-01652:unable to extend temp segment by num in tablespace name
- unable to extend temp segment by 128 in tablespace name
- ORA-01652: unable to extend temp segment by 128 in tablespace TEMP
- ORA-01652: unable to extend temp segment by 128 in tablespace TEMP
- java.sql.SQLException: ORA-01652: unable to extend temp segment by 128 in tablespace TEMP
- 临时表空间不够ORA-01652: unable to extend temp segment by 128 in tablespace TEMP
- ORA-20000: -1652:ORA-01652: unable to extend temp segment by 8192 in tablespace
- ORA-01652 unable to extend temp segment by string in tablespace string
- ORA-01652: unable to extend temp segment by 128 in tablespace TEMP01
- ORA-01652: unable to extend temp segment by 128 in tablespace TB1
- ORA-01652: unable to extend temp segment by 128 in tablespace TEMP01
- ORA-01652:unable to extend temp segment by 128 in tablespace TEMPTS1
- ORA-1652: unable to extend temp segment by 128 in tablespace TEMP
- ORA-01688:unable to extend table name。name partition NAME by NUM in tablespace NAME
- ORA-1652错误 unable to extend temp segment by 128 in tablespace
- ORA-1652: unable to extend temp segment by 128 in tablespace
- 关于Manber-Mayer suffix array 构造算法
- Silverlight自定义数据绑定控件应该如何处理IEditableObject和IEditableCollectionView对象
- Linux中查看系统资源占用情况的命令
- python端口扫描
- C# 给线程传数据的两种方法【C#高级教程整理】
- ORA-01652:unable to extend temp segment by num in tablespace name
- calloc与malloc的区别
- “.NET 4.0 网络开发入门之旅系列文章”—— IP 知多少?(下)
- 学习新的控制芯片ARM
- opencore内部调度
- 雨林木风 Ghost XP SP3 装机2010圣诞节专版
- UML类图解义
- T-tree C++实现源代码
- 关于Flash Player详细说明