Re: HELP ORA-00600: internal error code

I ran into a similar problem once with Oracle 7.3 on Win NT4 and as I seem to remember it was a corrupted index block. I think you can fix this by dropping the index(s) and re-creating them all. I think you can check for corruption by issuing the following query:

analyze table <table_name> validate structure cascade; or
analyze index <index_name> validate structure;

Please correct if I'm wrong on this.

mkb

Ýììàíóåë Óõóíâàíãõî wrote:

> 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 - 11:57:12 CDT