The following tables have an error:
CREATE TABLE REQ_ROB_EQP (
REQ_PER_ROB_ID NUMBER,
REQ_EQU_NOME VARCHAR(100),
CONSTRAINT REQ_ID_NOME_PK PRIMARY KEY (REQ_PER_ROB_ID, REQ_EQU_NOME)
--CONSTRAINT REQ_PER_ROB_ID_FK FOREIGN KEY (REQ_PER_ROB_ID) REFERENCES ROB_ROBOTICO(ROB_PER_ID),
--CONSTRAINT REQ_EQU_NOME_FK FOREIGN KEY (REQ_EQU_NOME) REFERENCES EQU_EUIPAMENTO(EQU_NOME)
);
CREATE TABLE MOD_ARM_FOR (
MOD_ARM_NOME VARCHAR(100),
MOD_FOR_MODELO VARCHAR(100),
CONSTRAINT MOD_NOME_MODELO_PK PRIMARY KEY (MOD_ARM_NOME, MOD_FOR_MODELO),
CONSTRAINT MOD_ARM_NOME_FK FOREIGN KEY (MOD_ARM_NOME) REFERENCES ARM_ARMA(ARM_NOME),
CONSTRAINT MOD_FOR_MODELO_FK FOREIGN KEY (MOD_FOR_MODELO) REFERENCES FOR_FORMA(FOR_MODELO)
);
Referenced tables exist and are working perfectly. I even commented on fk to see if it was a bug there, but the problem persists. Here is the error:
Error report - ORA-00904: "REQ_PER_ROB_ID": invalid identifier 00904. 00000 - "% s: invalid identifier"
from the second table:
Error report - ORA-00904: "MOD_ARM_NAME": invalid identifier 00904. 00000 - "% s: invalid identifier"