Regarding Oracle Error

I am getting the below oracle error. I checked the test scheme for any constraint name CMF_CMP using toad. But i am unable to find it. How do i detect the reason for failure and how to resolve it.

ERROR at line 1:
ORA-20001: -2298: ORA-02298: cannot validate (TEST.FMF_CMP) - parent keys not found
ORA-06512: at test.test_SYN", line 46

Answers


Sounds like you have an orphan! You'll need to track it down and give it a parent or drop the orphan

http://www.techonthenet.com/oracle/errors/ora02298.php

select * 
  from test_SYN ts
 where PARENTID not EXISTS(
                           select NULL 
                             from test_PARENT tp
                            where tp.ID = ts.ParentID)

Are you trying to enable the constraint or am I just missing the mark?


Need Your Help

Sort array on two parameters in swift

arrays sorting swift parameters

I want to sort an array on two parameters, for example, name and then by description.

Excel VBA Password via Hex Editor

excel vba excel-vba hex-editors

I have used the "Hex Editor to modify DPB to DPx" many times in the past to bypass VBA project security on my old Excel VBA projects (.xls), so I definitely know how to do it and know that I can do...