我在一个数据库上执行如下语句
select a.RecordTime, a.USERID, a.MOMSCount, b.SPID, b.SPMSCount
from (select rownum rn, c.recordtime, c.userid, c.momscount
from tb1 c where rownum < 10
) a
full join (select rownum rn, d.spid, d.spmscount
from tb2 d
where rownum < 10
) b on a.rn = b.rn
报ORA-03113错误.
数据库是11g的 系统是SUCE LINUX
但在另外一个系统下执行没有问题 另外一个库也是11G 系统是aix 如何解决?
select a.RecordTime, a.USERID, a.MOMSCount, b.SPID, b.SPMSCount
from (select rownum rn, c.recordtime, c.userid, c.momscount
from tb1 c where rownum < 10
) a
full join (select rownum rn, d.spid, d.spmscount
from tb2 d
where rownum < 10
) b on a.rn = b.rn
报ORA-03113错误.
数据库是11g的 系统是SUCE LINUX
但在另外一个系统下执行没有问题 另外一个库也是11G 系统是aix 如何解决?
ORA-03113: end-of-file on communication channel
Cause: The connection between Client and Server process was broken.
Action: There was a communication error that requires further investigation. First, check for network problems and review the SQL*Net setup. Also, look in the alert.log file for any errors. Finally, test to see whether the server process is dead and whether a trace file was generated at failure time.
供参考..
select a.RecordTime,a.USERID,a.MOMSCount,b.SPID,b.SPMSCount
from (select rownum rn,c.* from tb1 c where rownum<101) a ,
(select rownum rn,d.* from tb2 d where rownum<101) b
where a.rn = b.rn
可以执行
from (select rownum rn,c.* from tb1 c where rownum <101) a ,
(select rownum rn,d.* from tb2 d where rownum <101) b
where a.rn = b.rn
关注。