Home » RDBMS Server » Server Utilities » Error During IMPDP (11gr2 LINUX)
Error During IMPDP [message #559822] Fri, 06 July 2012 10:13 Go to next message
chandu208
Messages: 17
Registered: July 2012
Junior Member
while i'm importing schemas i came accross

ORA-29913: error in executing ODCIEXTTABLEFETCH callout
ORA-02291: integrity constraint (STATICO.FK_PROD_REQ_LIS_TAG_GEN_2) violated - parent key not found
ORA-31693: Table data object "STATICO"."PROD_REQ_LIS_TAG_GEN":"GEN_DS_LOAN" failed to load/unload and is being skipped due to error:

any sugessions?
Re: Error During IMPDP [message #559825 is a reply to message #559822] Fri, 06 July 2012 10:29 Go to previous messageGo to next message
BlackSwan
Messages: 26733
Registered: January 2009
Location: SoCal
Senior Member
>ORA-02291: integrity constraint (STATICO.FK_PROD_REQ_LIS_TAG_GEN_2) violated - parent key not found
don't import orphan records.

Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/
Re: Error During IMPDP [message #559827 is a reply to message #559822] Fri, 06 July 2012 10:35 Go to previous message
Michel Cadot
Messages: 67369
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
What don't you understand in the message?
Either remove the contraint or the offending data.

Regards
Michel
Previous Topic: datapump Exclude Parameter
Next Topic: Schema level export with particular partition tables
Goto Forum:
  


Current Time: Thu Sep 24 04:11:51 CDT 2020