Ok dah beres mas, Thanks in advance ... Rgrds, Arie
--- In [email protected], "Yulius Wibowo" <[EMAIL PROTECTED]> wrote: > > 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" <arie7474@> 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 > > >
