SQL Error: ORA-02298: cannot validate (SYSTEM.AEROPUERTO_FK) - parent keys not found
There are records in AEROPUERTO
that point to records that do not exist in CIUDAD
.
To find out which records of AEROPUERTO
have that kind of issue:
select * from AEROPUERTO where CODIGO_CIUDAD not in (select CODIGO from CIUDAD)
If the result set is not empty, you do have orphanaged records. You'll need to add the missing CIUDAD
records in order to create the AEROPUERTO_FK
foreign key, or update all the erroneous AEROPUERTO.CODIGO_CIUDAD
to null (if this is a nullable field, but you will lose the city information for those airport records).
remove primary key constraint from the column in which you want to add the foreign key