DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: ora2291 error

  1. #1
    Join Date
    May 2001
    Posts
    1

    Angry

    hi people

    take a look at

    http://www.geocities.com/anony_mousuk/tables2.TXT

    im trying to design a database from that data..

    now all the tables are creating fine and ok..

    but when i get to the tool contract lines i get the error

    ORA-02291: integrity constraint (OCLA041.PK_CI_TOOL_CONTRACTS) violated -
    parent key not found


    i have no idea?

    any one can help please?

    thanks
    saj

  2. #2
    Join Date
    Sep 2000
    Posts
    47
    Hi Saj,

    The parent key (in TOOL_CONTRACTS) is not found for the values being inserted in TOOL_CONTRACT_LINES. The values for CONTRACT_ID in TOOL_CONTRACT_LINES are: 'AZ15', 'AZ16', 'AZ17', etc. but the values present in TOOL_CONTRACTS are 'Az15', 'Az16', 'Az17', etc. (the character 'z' is in lower case). Make this correction and the script will work fine.

    Good Luck.

    Pinakin.

  3. #3
    Join Date
    Apr 2001
    Posts
    51
    Kindly goto this site again. and check for data in the following 2 tables. TOOL_CONTRACTS and TOOL_CONTRACT_LINES. The data doesn't match for the contract_id columns. This is the error.

    Hope this helps u. All The Best.

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