Problems using FOREIGN KEYs

From: Dirk Fleischmann, HRZ-HiWi <fleischmann_at_hrz1.hrz.th-darmstadt.de>
Date: Sat, 26 Nov 1994 23:03:54 GMT
Message-ID: <fleischmann.11.2ED7BEDA_at_hrz1.hrz.th-darmstadt.de>


After defining the following database tables everthing works fine.

CREATE TABLE TestBenutzer

      (BN_ID                    NUMBER(15) NOT NULL,
       GR_ID                    NUMBER(15) NULL,
       BN_Name                  VARCHAR2(30) NOT NULL,
       BN_Vorname               VARCHAR2(30) NULL,
       BN_Abtbezeichnung        VARCHAR2(30) NULL

);

CREATE UNIQUE INDEX XPKTestBenutzer
  ON TestBenutzer
(

BN_ID                            ASC

);

CREATE TABLE Gruppe

      (GR_ID                    NUMBER(15) NOT NULL,
       GR_Name_kurz             VARCHAR2(30) NOT NULL,
       GR_Beschreibung          VARCHAR2(80) NULL

);

CREATE UNIQUE INDEX XPKGruppe
  ON Gruppe
(

GR_ID                            ASC

);

ALTER TABLE TestBenutzer
ADD ( PRIMARY KEY (BN_ID) )
;

ALTER TABLE Gruppe
ADD ( PRIMARY KEY (GR_ID) )
;

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

---
Dirk Fleischmann        Hochschulrechenzentrum, TH Darmstadt
Petersenstrasse 30                          __o    
64287 Darmstadt                           _`\<,_   
Germany                                  (_)/ (_)
E-Mail (Internet): fleischmann_at_hrz.th-darmstadt.de
Received on Sun Nov 27 1994 - 00:03:54 CET

Original text of this message