Dump file d:\oracle\admin\osfdb\udump\osfdb_ora_2364.trc
Tue Jun 13 11:53:51 2006
ORACLE V9.2.0.1.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.0 Service Pack 4, CPU type 586
Oracle9i Release 9.2.0.1.0 - Production
JServer Release 9.2.0.1.0 - Production
Windows 2000 Version 5.0 Service Pack 4, CPU type 586
Instance name: osfdb
Redo thread mounted by this instance: 1
Oracle process number: 14
Windows thread id: 2364, image: ORACLE.EXE
*** SESSION ID
24.53249) 2006-06-13 11:53:51.000
*** 2006-06-13 11:53:51.000
ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [qctcte1], [0], [], [], [], [], [], []
Current SQL statement for this session:
SELECT categoryid,categorytype,categorymapid,
categoryname,upcategoryid,classtype,
remark,startphone,endphone,description
from (
select nvl(a.categoryid,b.categoryid) categoryid, nvl(a.categorytype,b.categorytype) categorytype,
nvl(a.categorymapid,b.categorymapid) categorymapid, nvl(a.categoryname,b.categoryname) categoryname,
nvl(a.upcategoryid,b.upcategoryid) upcategoryid, nvl(a.classtype,b.classtype) classtype,
nvl(a.remark,b.remark) remark, b.startphone startphone,
b.endphone endphone, b.description description, rownum r
from
(select categoryid,categorytype,categorymapid,
categoryname,upcategoryid,classtype,remark
from t_sectioncategorymap
where categorytype = :b1
and (classtype = 2 or classtype = 1)
) a
full outer join
(select c.categoryid, d.categorytype,d.categorymapid,d.categoryname,
d.upcategoryid,d.classtype,d.remark,c.startphone,c.endphone,c.description
from t_phonesection c,t_sectioncategorymap d
where c.categoryid = d.categoryid
and c.categorytype = :b1
and d.classtype = 3
) b
on a.categoryid = b.categoryid
)
|