My Oracle Support Banner

Unable to Move Data Between MDM Environments Error With Impdb, "ORA-00001: unique constraint (CISADM.SYS_C0013700) violated" (Doc ID 2479541.1)

Last updated on DECEMBER 04, 2019

Applies to:

Oracle Utilities Meter Data Management - Version 2.2.0.1.0 and later
Information in this document applies to any platform.

Symptoms

**Any examples provided in this article do not represent real life personal/confidential information**

**Disclaimer:** This KM article may include the following abbreviations:

MDM - Oracle Utilities Meter Data Management

Encountering a an error where certain tables needs to be moved from one MDM environment to another MDM environment.  Those tables should be appended and not overridden as per the business requirement.
So have taken full dump from source DB and used below command to import into destination DB encounters an error.


Error:
ORA-00001: unique constraint (CISADM.SYS_C0013700) violated




STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. create full db dump from SOURCE_DB
2. import to DESTINATION_DB with following command: impdp system/***** TABLES=CISADM.F1_BUS_OBJ, CISADM.F1_BUS_OBJ_L,CISADM.F1_BUS_OBJ_OPT,CISADM.F1_BUS_OBJ_STATUS,CISADM.F1_BUS_OBJ_STATUS_ALG, CISADM.F1_BUS_OBJ_STATUS_L,CISADM.F1_BUS_OBJ_STATUS_OPT,CISADM.F1_BUS_OBJ_TR_RULE,CISADM.F1_BUS_OBJ_TR_RULE_L, CISADM.F1_SCHEMA directory=DATA_PUMP_DIR TABLE_EXISTS_ACTION=APPEND dumpfile=CISADM.DMP logfile=Append.log
3. Observe error in log ORA-00001: unique constraint (CISADM.SYS_C0013700) violated

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.