| impdp error [message #527400] |
Tue, 18 October 2011 01:19  |
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  |
 |
Littlefoot
Messages: 21823
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?
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
