Re: Problems using FOREIGN KEYs

In article <fleischmann.11.2ED7BEDA_at_hrz1.hrz.th-darmstadt.de> fleischmann_at_hrz1.hrz.th-darmstadt.de (Dirk Fleischmann, HRZ-HiWi) writes:

[stuff deleted]

   But after altering the table "TestBenutzer"

   ALTER TABLE TestBenutzer
   ADD ( FOREIGN KEY (GR_ID)

                  REFERENCES Gruppe) 

   the message

   Message: ORA-00600:internal error code, arguments:[12832],[],[],[],[],[],[],[]

   is displayed if you try to insert a new row into the table "TestBenutzer".

   The Oracle 7 manual "Messages and Codes" advices to report this problem to    "World Wide Customer Support", because it is an internal exception, but we    believe there is an mistake in our definition.

   We are using Oracle 7 running on a NetWare 3.11-Server.

   Is anybody able to help us?

   Ciao
   Dirk Fleischmann and Frank Wolf

This is a known Oracle error, it is nothing wrong with your definition. It's over a year since the first time I myself experienced this problem. You may try to recreate the primary and foreign key definitions.

It seems that the error occurs randomly. Oddly enough, we had this problem frequently when our database was small. Now that our database is 'larger' the problem seems not to occur anymore. We are still using the same Oracle version as before.
Oh, by the way, we don't expicitly create the unique indexes, only the primary keys.

Remember: Todays Oracle and the Oracle in Delphi has one thing in common: They both occasionally return nonpredictable results.

--
Oddmund.Johannessen_at_delab.sintef.no