This discussion is archived
4 Replies Latest reply: Sep 3, 2013 6:21 AM by Dean Gagne RSS

impdp EXCLUSE= REF_CONSTRAINT, and CONSTRAINT being ignored..?

cayenne Newbie
Currently Being Moderated

Hello all,

 

I'm running impdp for a DATA_ONLY import to a single schema.

 

I have set:

 

EXCLUDE=REF_CONSTRAINT

EXCLUDE=CONSTRAINT

SCHEMAS=SCHEMA1

CONTENT=DATA_ONLY

In my par file.

 

However, when importing I still get several errors such as:

 

Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA

ORA-31693: Table data object "SCHEMA1"."STD_TABLE1" failed to load/unload and is being skipped due to error:

ORA-02091: transaction rolled back

ORA-02291: integrity constraint (SCHEMA1.FKSTD_CONSTRAINT_NAME1) violated - parent key not found

. . imported "SCHEMA1"."STD_TABLE2"                3.672 MB   35023 rows

ORA-31693: Table data object "SCHEMA1"."STD_TABLE3" failed to load/unload and is being skipped due to

error:

ORA-02091: transaction rolled back

ORA-02291: integrity constraint (SCHEMA1.FKSTD_CONSTRAINT_NAME2) violated - parent key not found

 

 

 

These are foreign keys, any suggestions on what to look for as to why these constraints aren't being overlooked so the tables can be loaded?

 

Is there something else I need to exclude in order to get these tables loaded?

 

Thanks in advance,

 

cayenne

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points