OraFAQ Forum: Server Utilities » Error During IMPDP

Home » RDBMS Server » Server Utilities » Error During IMPDP (11gr2 LINUX)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Error During IMPDP [message #559822]

Fri, 06 July 2012 10:13

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?

Report message to a moderator

Re: Error During IMPDP [message #559825 is a reply to message #559822]

Fri, 06 July 2012 10:29

BlackSwan
Messages: 26766
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/

Report message to a moderator

Re: Error During IMPDP [message #559827 is a reply to message #559822]

Fri, 06 July 2012 10:35

Michel Cadot
Messages: 68774
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

What don't you understand in the message?
Either remove the contraint or the offending data.

Regards
Michel

Report message to a moderator

Previous Topic:	datapump Exclude Parameter
Next Topic:	Schema level export with particular partition tables

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Jan 27 11:30:05 CST 2026