My Oracle Support Banner

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

Last updated on AUGUST 04, 2018

Applies to:

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


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

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



To view full details, 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 a vibrant support community of peers and Oracle experts.