ora2291 error

[saj]

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

[Pinakin]

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.

[miritika]

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.