Home » RDBMS Server » Server Administration » ORA-600 [17182] when using DESC in a simple query
ORA-600 [17182] when using DESC in a simple query [message #51435] |
Thu, 23 May 2002 00:27 |
Sylvain Fauvel
Messages: 4 Registered: May 2002
|
Junior Member |
|
|
Hello.
I need help please, can't understand....
I'm working on a server 8.1.5 on NT 4 SP6.
Via SQLPLUS, i launch this query :
select
agt_ref,
agt_nom,
agt_pwd,
agt_tel,
ppragt.prf_cod,
prf_lib
from ppragt, pprprf
where pprprf.prf_cod=ppragt.prf_cod
order by prf_lib desc;
It may work one, two or three times, but it finally returns an ORA-600 error as follows :
(This is a part of SQL trace file)
*** SESSION ID:(10.26630) 2002.05.22.15.41.21.811
XCTEND rlbk=0, rd_only=1
=====================
PARSING IN CURSOR #1 len=34 dep=0 uid=97 oct=42 lid=97 tim=8826602 hv=2195525345 ad='441eca8'
alter session set sql_trace=true
END OF STMT
EXEC #1:c=0,e=0,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=8826602
=====================
PARSING IN CURSOR #1 len=157 dep=0 uid=97 oct=3 lid=97 tim=8826602 hv=1945775368 ad='4150814'
select
agt_ref,
agt_nom,
agt_pwd,
agt_tel,
ppragt.prf_cod,
prf_lib
from ppragt, pprprf
where pprprf.prf_cod=ppragt.prf_cod
order by prf_lib desc
END OF STMT
PARSE #1:c=0,e=0,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=8826602
XCTEND rlbk=0, rd_only=1
EXEC #1:c=0,e=0,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=8826603
FETCH #1:c=0,e=0,p=0,cr=4,cu=8,mis=0,r=15,dep=0,og=4,tim=8826617
********** Internal heap ERROR 17182 addr=0xa1c7948 *********
***** Dump of memory around addr 0xa1c7948:
A1C7740 00000004 00000003 00000000 00000019 0A1C76E0 00CCE884
A1C7760 0000000C 00000000 00000000 00000029 0A1C7754 00E12EB4 00000004 00000000
A1C7780 00000000 00000000 0A1C76EC 0A1C7760 00000000 000001B5 0A1C776C 00CCE884
(This is a part of the INSTANCE_NAME_ALRT.LOG)
Wed May 22 19:13:40 2002
Errors in file D:OracleOra81rdbmstraceORA00235.TRC:
ORA-00600: code erreur interne, arguments : [[17182]], [[3253044]], [[]], [[]], [[]], [[]], [[]], [[]]
ORA-00600: code erreur interne, arguments : [[17182]], [[3253044]], [[]], [[]], [[]], [[]], [[]], [[]]
If i don't use the final "DESC" in the ORDER clause, there is no error...if i delete the WHERE... the problem disappears also.
I already have dropped all the indexes on the fields...
Can anybody help me ??
|
|
|
|
|
Goto Forum:
Current Time: Thu Sep 19 19:04:29 CDT 2024
|