Mas, itu artinya ada beberapa record yg "tidak valid" untuk column FILE_SID di table DC.DPH_QUEUE.
Coba di cek dulu data2nya, SQL> SELECT * FROM DC.DPH_QUEUE WHERE FILE_SID NOT IN (SELECT FILE_SID FROM DC.FILE_DEF); CMIIW, Bowo --- In [email protected], "Arie" <[EMAIL PROTECTED]> wrote: > > Frenz, > > Ada yg bisa bantuin ga. Aku coba bikin constraint di oracle > dengan command: > > ALTER TABLE DC.DPH_QUEUE > ADD CONSTRAINT DPH_QUEUE_FILE_DEF > FOREIGN KEY (FILE_SID) > REFERENCES DC.FILE_DEF (FILE_SID); > > Cuma muncul error: > > ORA-02298: cannot validate (DC.DPH_QUEUE_FILE_DEF) - parent keys not > found > > Aku sdh cari solusi di google, caranya: > > Error: ORA-02298: cannot validate (DC.DPH_QUEUE_FILE_DEF) - parent > keys not found > > Cause: You tried to execute an ALTER TABLE ENABLE CONSTRAINT > command, but it failed because your > table has orphaned child records in it. > > Action: The options to resolve this Oracle error are: > 1. Remove the orphaned child records from the child table > (foreign key relationship), and > then re-execute the ALTER TABLE ENABLE CONSTRAINT command. > 2. Create the missing parent records in the parent table > (foreign key relationship), then > re-execute the ALTER TABLE ENABLE COSNTRAINT command. > > Cuma aku belum nangkap maksudnya, mohon petunjuknya dong.. > > Rgrds, > Arie >
