ORA600 [17182] with svrmgrl, and SQL Explorer
From: Nicole Leduc <nleduc_at_mediane-info.fr>
Date: Tue, 07 Mar 2000 16:30:06 +0100
Message-ID: <38C5207E.189D_at_mediane-info.fr>
With svrmgrl on a client PC, when we do a SELECT on a table, (selecting all the columns - 290 000 records), we get an ORA-600 error with first parameter [17182].
But, any of you - any idea ?
Date: Tue, 07 Mar 2000 16:30:06 +0100
Message-ID: <38C5207E.189D_at_mediane-info.fr>
With svrmgrl on a client PC, when we do a SELECT on a table, (selecting all the columns - 290 000 records), we get an ORA-600 error with first parameter [17182].
The statement is like this :
SELECT "SRB_ID" ,"VEP_ID" ,"ANA_DAT" ,"ANA_NSI" ,
"ANA_MNT1" ,"ANA_MNT2" ,"ANA_ENT"
FROM "GFPFANA"
ORDER BY "VEP_ID" DESC , "SRB_ID" DESC , "ANA_NSI" DESC
Same error with Inprise SQL Explorer, when we scroll
on this table, on the screen.
Additional informations :
- timed_statistic is FALSE
- nls_sort is null - I added a key in my client PC's registry where nls_sort=binary a few weeks ago, but just deleted it and re-started the PC - same error.
- no bitmap index is used in the query written in the trace file.
- O8.1.5 on AIX
- Client PC : Win98 - O8i and O8 client installed
- BDE 5.10 - ORACLE 8 DRIVER UPDATE 1
But, any of you - any idea ?
-Nicole Received on Tue Mar 07 2000 - 16:30:06 CET