Home » RDBMS Server » Server Administration » ORA - 02291
ORA - 02291 [message #371343] Thu, 05 October 2000 08:21 Go to next message
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 Go to previous message
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.
Previous Topic: Date Calculation
Next Topic: Query
Goto Forum:
  


Current Time: Thu Mar 28 18:32:32 CDT 2024