Impdp Fails ORA-31693: Table Data Object Failed To Load/unload And Is Being Skip (Doc ID 1624857.1)

Last updated on JANUARY 09, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.5 and later
Information in this document applies to any platform.
***Checked for relevance on 9-Jan-2017***

Symptoms

When attempting to import a single table with impdp the following errors occur:

...
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
ORA-31693: Table data object "OPICS_TEST"."DLDT" failed to load/unload and is being skipped due to error:
ORA-20001: 43
ORA-04092: cannot ROLLBACK in a trigger
ORA-00001: unique constraint (OPICS_TEST.FINDPK) violated
----- PL/SQL Call Stack -----
 object      line  object
 handle    number  name
3aa24f738        84  OPICS_TEST.TR_FIND_ADD
3add38190      1204  package body SYS.DBMS_SYS_SQL
3b4972400       323  package body SYS.DBMS_SQL
3b6e2b5f0      1112  package body SYS.KUPD$DATA
3b6e2b5f0      1496
Job "OPS$ORATPS"."SYS_IMPORT_TABLE_01" completed with 1 error(s) at 11:38:40

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms