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