Restituisci
-
Titolo
ORA-02298 received after repairing a table and attempting to re-enable foreign key constraints. -
Descrizione
The following errors are received after fixing out of sync on parent and child table(s) and an attempt is made to re-enable the foreign key constraint on a child table:
SQL> alter table OWNER.TABLE_NAME ENABLE constraint OWNER.CONSTRAINT_NAME;
alter table OWNER.TABLE_NAME ENABLE constraint OWNER.CONSTRAINT_NAME
*
ERROR at line 1:
ORA-02298: cannot validate (OWNER. CONSTRAINT_NAME) - parent keys not found
Accesso richiesto
Per visualizzare gli articoli della Knowledge Base di livello avanzato, è necessario aver effettuato l'accesso e disporre di un contratto di manutenzione in essere.