Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> HELP ORA-00600: internal error code

HELP ORA-00600: internal error code

From: Ýììàíóåë Óõóíâàíãõî <uhemm_at_infotel.ru>
Date: Wed, 14 Oct 1998 18:45:46 +0300
Message-ID: <3624C72A.B282DDAC@infotel.ru>


Can any one explain this error!!!
ORA-00600: internal error code, arguments: [12700], [604082229], [2], [], [], [], [], []

it is produced when i issue the following statment:

   select id from acs_prices
   where tg_id=1 and srv_id=1 and tt_id=3  but when this same statement with different values is issued ie

       select id  from acs_prices
      where tg_id=1 and srv_id=1 and tt_id=1
every thing works fine

the sructure of the acs_prices table is

CREATE TABLE ACS_PRICES
 (ID NUMBER NOT NULL
,TARIF_POSITION VARCHAR2(15) NOT NULL
,AMOUNT1 NUMBER(8,2) DEFAULT 0
,AMOUNT2 NUMBER(8,2) DEFAULT 0
,START_TIME DATE
,STOP_TIME DATE
,DESTINATION VARCHAR2(255)
,SRV_ID NUMBER NOT NULL
,TT_ID NUMBER NOT NULL
,TG_ID NUMBER NOT NULL

 )

ALTER TABLE ACS_PRICES ADD CONSTRAINT
 PR_PK PRIMARY KEY
  (ID)

ALTER TABLE ACS_PRICES ADD CONSTRAINT
 PR_TG_FK FOREIGN KEY
  (TG_ID) REFERENCES ACS_TARIF_GROUPS
  (ID)
 ADD CONSTRAINT
 PR_SRV_FK FOREIGN KEY
  (SRV_ID) REFERENCES ACS_SERVICES
  (ID)
 ADD CONSTRAINT
 PR_TT_FK FOREIGN KEY
  (TT_ID) REFERENCES ACS_TARIF_TYPES
  (ID)

CREATE INDEX PR_SRV_FK_I ON ACS_PRICES  (SRV_ID)
/

CREATE INDEX PR_TT_FK_I ON ACS_PRICES
 (TT_ID)
/

CREATE INDEX PR_TG_FK_I ON ACS_PRICES
 (TG_ID)
/ Received on Wed Oct 14 1998 - 10:45:46 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US