ORA-01652: unable to extend temp segment by 128 in tablespace TEMP的问题.
用于WEB项目中的大数据量分页的存储过程,用传递SQL语句至存储过程,而后用ROWNUM来取每页X条的原理,现在在某个SQL语句时会出错,错误为(ORA-01652: unable to extend temp segment by 128 in tablespace TEMP.) 其它的SQL查询语句都能正常使用,出错SQL语句如下:
SELECT * FROM (
SELECT A.*, rownum rn
FROM (
select FileName,Line,
to_char(RECEIVE_TM, 'yyyy-mm-dd hh24:mi:ss'),
to_char(db_insr_tm, 'yyyy-mm-dd hh24:mi:ss'),
to_char(Sent_tm, 'yyyy-mm-dd hh24:mi:ss'),
from vwallfiles, vw_file_trans_log
where vwallfiles.FILENAME = vw_file_trans_log.ori_file_nm
and Upper(cust_carrier_cd) = Upper('HKGPP')
and errortype <> 'Missing'
and errortype <> 'Fatal'
and upper(partner_carrier_cd) = upper('chnct')
and 1 = 1
and biz_line = 1
) A WHERE rownum <= 40
) B WHERE rn >= 21
出现这问题后,我已把ORACLE 的表空间增大数倍,但还是出现此错误,请大家帮忙查查问题,谢谢.