4 Replies Latest reply: Sep 3, 2013 8:21 AM by Dean Gagne-Oracle RSS

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

    cayenne

      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