Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> HELP ORA-00600: internal error code
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=1every 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
![]() |
![]() |