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
