Hallo, kann mir jemand sagen warum der Fehler auftritt, habe nach Lösungen gesucht aber nichts hat geholfen.
CREATE TABLE Land(
LandID INTEGER NOT NULL,
LandName VARCHAR2(30) NOT NULL,
CONSTRAINT size_Land CHECK (LandName >= 2),
CONSTRAINT Land_pk PRIMARY KEY(LandName)
);
CREATE TABLE Adresse(
AdrID INTEGER NOT NULL,
LandID INTEGER NOT NULL,
PLZ INTEGER NOT NULL,
HausNr INTEGER NOT NULL,
Straße VARCHAR2(30) NOT NULL,
Stadt VARCHAR2(30) NOT NULL,
CONSTRAINT Adresse_pk PRIMARY KEY (AdrID),
CONSTRAINT Adresse_fk FOREIGN KEY (LandID) REFERENCES Land (LandID)
);
Fehlermeldung:
Fehler beim Start in Zeile: 8 in Befehl -
CREATE TABLE Adresse(
AdrID INTEGER NOT NULL,
LandID INTEGER NOT NULL,
PLZ INTEGER NOT NULL,
HausNr INTEGER NOT NULL,
Straße VARCHAR2(30) NOT NULL,
Stadt VARCHAR2(30) NOT NULL,
CONSTRAINT Adresse_pk PRIMARY KEY (AdrID),
CONSTRAINT Adresse_fk FOREIGN KEY (LandID) REFERENCES Land (LandID)
)
Fehlerbericht -
ORA-02270: kein entsprechender Primär- o. eindeutiger Schlüssel für diese Spaltenliste
02270. 00000 - "no matching unique or primary key for this column-list"
*Cause: A REFERENCES clause in a CREATE/ALTER TABLE statement
gives a column-list for which there is no matching unique or primary
key constraint in the referenced table.
*Action: Find the correct column names using the ALL_CONS_COLUMNS
catalog view
CREATE TABLE Land(
LandID INTEGER NOT NULL,
LandName VARCHAR2(30) NOT NULL,
CONSTRAINT size_Land CHECK (LandName >= 2),
CONSTRAINT Land_pk PRIMARY KEY(LandName)
);
CREATE TABLE Adresse(
AdrID INTEGER NOT NULL,
LandID INTEGER NOT NULL,
PLZ INTEGER NOT NULL,
HausNr INTEGER NOT NULL,
Straße VARCHAR2(30) NOT NULL,
Stadt VARCHAR2(30) NOT NULL,
CONSTRAINT Adresse_pk PRIMARY KEY (AdrID),
CONSTRAINT Adresse_fk FOREIGN KEY (LandID) REFERENCES Land (LandID)
);
Fehlermeldung:
Fehler beim Start in Zeile: 8 in Befehl -
CREATE TABLE Adresse(
AdrID INTEGER NOT NULL,
LandID INTEGER NOT NULL,
PLZ INTEGER NOT NULL,
HausNr INTEGER NOT NULL,
Straße VARCHAR2(30) NOT NULL,
Stadt VARCHAR2(30) NOT NULL,
CONSTRAINT Adresse_pk PRIMARY KEY (AdrID),
CONSTRAINT Adresse_fk FOREIGN KEY (LandID) REFERENCES Land (LandID)
)
Fehlerbericht -
ORA-02270: kein entsprechender Primär- o. eindeutiger Schlüssel für diese Spaltenliste
02270. 00000 - "no matching unique or primary key for this column-list"
*Cause: A REFERENCES clause in a CREATE/ALTER TABLE statement
gives a column-list for which there is no matching unique or primary
key constraint in the referenced table.
*Action: Find the correct column names using the ALL_CONS_COLUMNS
catalog view