Internal ora-00600
Date: Thu, 23 Sep 1993 19:27:46 GMT
Message-ID: <CDtnEB.2C5_at_ra.nrl.navy.mil>
When I execute the sequence of queries below under oracle server release 7.0.12.10 - Production, using SQL*Plus: Release 3.1.1.9.1 on a Sun SPARCsystem 300 running SunOS 4.1.3, I get
ora-00600: internal error code, arguments:[18999], [], [], [], [], [], [], []
when sqlplus attempts to execute the first delete statement.
When the same sequence of queries is executed under oracle server v7.0.9.3.1 - Developer's Release, it works as expected.
Has anyone else experience error ora-00600 and know how to work-around it ?
Rodney Peyton
peyton_at_itd.nrl.navy.mil
-----------------------sequence of queries in question--------------------------
CREATE TABLE SINTRA#48 AS
SELECT * FROM sintra.trkid#C WHERE sintra.trkid#C.uic = 'N91703';
UPDATE SINTRA#48
SET ld = '17', ld# = 'S', lm = '29', lm# = 'S', lod = '-136', lod# = 'S', lom = '09', lom# = 'S', posdtg = '301523Z AUG', posdtg# = 'S', activity = 'Shadowing MV Fu Manchu', activity# = 'S', majorax = '5', majorax# = 'S', minorax = '1', minorax# = 'S', course = '230', course# = 'S', speed = '17', speed# = 'S', angle = '230', angle# = 'S';
DELETE FROM sintra.trkid#S
WHERE(SPEED, COURSE, MINORAX, MAJORAX, MAX_SPEED, DEST, ACTIVITY, ETADTG, TRACK, CALLSIGN, NOSICID, UIC, HULL, FLAG, SHIPNAME, CLASS, TYPE, POSDTG, LOM, LOD, LM, LD, MAXPICK, SENSOR, ALTITUDE, ANGLE, SPEED#, COURSE#, MINORAX#, MAJORAX#, MAX_SPEED#, DEST#, ACTIVITY#, ETADTG#, TRACK#, CALLSIGN#, NOSICID#, UIC#, HULL#, FLAG#, SHIPNAME#, CLASS#, TYPE#, POSDTG#, LOM#, LOD#, LM#, LD#, MAXPICK#, SENSOR#, ALTITUDE#, ANGLE#)
IN (SELECT SPEED, COURSE, MINORAX, MAJORAX, MAX_SPEED, DEST, ACTIVITY, ETADTG, TRACK, CALLSIGN, NOSICID, UIC, HULL, FLAG, SHIPNAME, CLASS, TYPE, POSDTG, LOM, LOD, LM, LD, MAXPICK, SENSOR, ALTITUDE, ANGLE, SPEED#, COURSE#, MINORAX#, MAJORAX#, MAX_SPEED#, DEST#, ACTIVITY#, ETADTG#, TRACK#, CALLSIGN#, NOSICID#, UIC#, HULL#, FLAG#, SHIPNAME#, CLASS#, TYPE#, POSDTG#, LOM#, LOD#, LM#, LD#, MAXPICK#, SENSOR#, ALTITUDE#, ANGLE# FROM SINTRA#48);
UPDATE sintra.trkid#S SET ld = '17', ld# = 'S', lm = '29', lm# = 'S',
lod = '-136', lod# = 'S', lom = '09', lom# = 'S', posdtg = '301523Z AUG',
posdtg# = 'S', activity = 'Shadowing MV Fu Manchu', activity# = 'S', majorax = '5', majorax# = 'S', minorax = '1', minorax# = 'S', course = '230', course# = 'S', speed = '17', speed# = 'S', angle = '230', angle# = 'S'WHERE sintra.trkid#S.uic = 'N91703';
INSERT INTO sintra.trkid#S SELECT * FROM SINTRA#48;
DROP TABLE SINTRA#48; Received on Thu Sep 23 1993 - 21:27:46 CEST