Invalid SQL identifier - Oracle

0
CREATE TABLE IndustrialUnit (
UnitId NUMBER (7,2) PRIMARY KEY,
Location_place VARCHAR(50),
Country VARCHAR (50),
FOREIGN KEY (ProdId) REFERENCES Production(ProdId)
);

When I try to set the FOREIGN KEY, the following error occurs: ORA-00904: "PRODID": Invalid identifier.

    
asked by anonymous 06.01.2018 / 19:40

1 answer

1

You did not create the ProdId column in this table (IndustrialUnit). in addition this column must be of the same type and not null in the Production table. check.

    
06.01.2018 / 21:15