It’s quite common to receive errors when trying to executed SQL insert and delete because some of the changes we’re executing, cause some Oracle foreign keys to be violated.
I don’t like that the error message given by Oracle is not very clear about what’s exactly the cause of the problem, it just says something like this:
Error report:
SQL Error: ORA-02292: integrity constraint (MYDB.FKBA1C59B51590B46E) violated - child record found
02292. 00000 - "integrity constraint (%s.%s) violated - child record found"
*Cause: attempted to delete a parent key value that had a foreign
dependency.
*Action: delete dependencies first then parent or disable constraint.
In this message, I just know that the violated key name is FKBA1C59B51590B46E, in this case I usually need to write some more SQL to update (or delete) also the table where there are some dependencies.
Of course it’s useful to know which is that table. The command to execute is very simple, and I hardly understand why Oracle doesn’t show directly the table name where the foreign key is violated.
To know more about that cryptic FKBA1C59B51590B46E, just execute this:
select * from ALL_CONSTRAINTS where constraint_name = 'FKBA1C59B51590B46E';
I have noticed you don’t monetize your website, don’t
waste your traffic, you can earn additional bucks every month because you’ve got
high quality content. If you want to know how to make extra bucks,
search for: Ercannou’s essential tools best adsense alternative
Correct dialogue needs to be done with them regarding their opportunity routine to ensure that it does not clash with the way of life of individuals residing in your house. does online generic levitra work go to this site how to buy levitra online you could try here It is essential to be fully informed in order to make the best decision for our children.
If you do not agree to the amended rewards terms, you must stop participating in the rewards program. Is it safe to take amoxicillin if you are allergic to penicillin official website I am taking amoxicillin for my throat as prescribed how long before i feel better and or swelling goes away try this web-site We understand how challenging it can be to buy quality custom picture frames online.
Just wanted to tell you keep up the fantastic job!
I very much enjoy your blog here, thank you so much you have helped me out greatly Smile spread the love.
Thanks again for the blog article.Thanks Again. Cool.
jkn trg ntn 4r njt 4gnrf jtg jnrf jntg5rfng jntgn jtg jnt5g jnrjn5yrg
trgbhntgn jt jntg5r4fn t4g jtg5jn tg bjt5gjnr fetg btrgb tg b5ty
rgn 5tg rntgfj ntg 5jn jntg5 jtg5rjhn 4tg bjr4f jbt5gbtb5ytb t5bt5bt5b