Home » RDBMS Server » Server Utilities » impdp error ( oracle 11g , solaris 10)
impdp error [message #527400] Tue, 18 October 2011 01:19 Go to next message
koff10
Messages: 58
Registered: December 2006
Location: france
Member
Hi ALL,
I get error while importing by using impdp :

ORA-39083: Object type REF_CONSTRAINT failed to create with error:
ORA-02298: cannot validate (PAPESR2_MB.FK_ALERTE_ALERTE_SO_SOUS_THE) - parent keys not found
Failing sql is:
ALTER TABLE "PAPESR2_MB"."ALERTE" ADD CONSTRAINT "FK_ALERTE_ALERTE_SO_SOUS_THE" FOREIGN KEY ("STH_ID") REFERENCES
"PAPESR2_MB"."SOUS_THEME" ("STH_ID") ENABLE .

thanks for help

koff10
Re: impdp error [message #527406 is a reply to message #527400] Tue, 18 October 2011 01:25 Go to previous message
Littlefoot
Messages: 21530
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
It is self-explainable: referential integrity constraint is violated because there are "child" records (in ALERTE table), but no "parent" records exist (in SOUS_THEME table).

How come? No idea; what did you do, exactly? Performed partial import? Deleted some parent records? Tried to enforce referential integrity but data is invalid? Something else?
Previous Topic: Excel Spreadsheet - SQLLDR - New Line Issues
Next Topic: ORA-00001: unique constraint violated error during impdp TABLE_EXISTS_ACTION=truncate content =data_
Goto Forum:
  


Current Time: Wed Feb 19 13:47:27 CST 2020