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 SEPTEMBER 19, 2022
Applies to:
Oracle Utilities Meter Data Management - Version 2.2.0.1.0 and laterInformation 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 |