Parent Key errors
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Thread: Parent Key errors

  1. #1
    Join Date
    Nov 2000
    Posts
    205
    I have been doing the import and to the best of my knowledge no one has been logged on during the export. I have being doing the tables in the order of dependency, but have received some errors stating that the parent key not found. This is for about a 100 thousand records.

    I checked on the source db and the contraints are still valid. Any clues as to how this could have happened?


    integrity constraint (FNDRYR0200.CTRL_CT_FK) violated - parent key not found


    Thanks,
    Nirasha

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    is this 8.1.6.3 or 8.1.7? There is a bug when import is creating PKs, basically you have to import with indexes=n otherwise when it's enabling constraints you will see something like xxx_pk already exists which is wrong, the index exists but not the constraint

  3. #3
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Are you exporting with consistent=y flag?
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  4. #4
    Join Date
    Nov 2000
    Posts
    205
    I am using 8.1.6.1. Nope, I did not see those errors about pk existing.

    I used the deafult export method, with just specifying compress =y and filesize parameters, so I am not sure.

    This whole process takes so long that tonight I am exploring the transportable tablespaces feature.

    I am posting a question in a new thread regarding this.

    Thanks guys for your help,
    Nirasha

  5. #5
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    If you export with consistent=y, your export will get a consistent view of the data. Search this forum for past discussions on this topic...
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  6. #6
    Join Date
    Nov 2000
    Posts
    205
    Thanks. I could not make out whether (by using imp help=y) consistent is a default or not.

    Nirasha

  7. #7
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    well try indexes=n in your import to see if you hit the bug I am tal,king about, if indexes=n solves your problem you certainly hit the bug

  8. #8
    Join Date
    Nov 2000
    Posts
    205
    I went the transportable tablespace option and it went great.

    Thanks,
    Nirasha
    Nirasha Jaganath

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width