ORA-02298: cannot validate- parent keys not found
*Cause: an alter table validating constraint failed because the table has child records.
*Action: Obvious
I liked this, so I thought I would throw up a quick post. (Sorry about the image quality; It was a scan.)
Anyone who has used Access or Oracle long enough, really pushing the boundaries of what they can do, has likely come across an error or two that the developers never expected you would see. ("Invalid Argument", "out of memory", "Not enough space on temporary disk" [with 100gb free])
And then there are error messages that just seem like lapses in judgment... ;)
If anyone wants to know, a quick google search turned up a nice solution here:
http://www.dbforums.com/archive/index.php/t-988439.html
(The error message would have made a lot more sense if it said orphaned child records.)
No comments:
Post a Comment