ora-02292 integrity constraint violated - child record found

Question

User442781244 posted

hi

guys

while i am updating my data in table getting above error.

i tried to disbale all constraints

..then did modfication but unable to enable all constraints once again

so masters plz suggest how to solve this issue

Answer 1

User1079421601 posted

Sometimes you may get error after disabling constraint. So, I suggest you to save your script and then delete all constraint. Then restart the database server and application server and then try.

Answer 2

User442781244 posted

hi

mahedee

ok..i will disable...no prblm in disabling the constraints ...but i am unbale to enable constraint once again..how to solve this issue....