| ORA - 02291 [message #371343] |
Thu, 05 October 2000 08:21  |
Samuel
Messages: 17
Registered: September 2000
|
Junior Member |
|
|
Hi,
i created many tables in oracle, after i create (with alter table add...) the foreign keys with references and the primary keys....
When i copy the data from sql server to oracle, the program give me the error 02291, if i create the table after i copy the data and after i alter tables.... ora give me the error 2298, why?
Can you help me, please?
thanks in advance
|
|
|
|
| Re: ORA - 02291 [message #371347 is a reply to message #371343] |
Thu, 05 October 2000 12:01  |
Andrew again...
Messages: 270
Registered: July 2000
|
Senior Member |
|
|
If you don't have Ora documentation, search on the net for those codes:
ORA-02291 integrity constraint (string.string) violated - parent key not found
Cause: A foreign key value has no matching primary key value.
Action: Delete the foreign key or add a matching primary key.
ORA-02298 cannot validate (string.string) - parent keys not found
Cause: An ALTER TABLE ENABLE CONSTRAINT command failed because the table has orphaned child records.
Action: Make sure that the table has no orphaned child records before issuing an ALTER TABLE ENABLE CONSTRAINT command. For more information about ALTER TABLE and ENABLE CONSTRAINT, see Oracle8i SQL Reference.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
