Home » RDBMS Server » Server Utilities » Import ERROR (Oracle Database 10g Enterprise Edition , 10.2.0.4.0,Linux64_86)
Import ERROR [message #654799] Sat, 13 August 2016 09:49 Go to previous message
abdo2203
Messages: 22
Registered: August 2016
Junior Member
I have two systems PROD and TEST of managing HR

i would like to import dump file from PROD to the TEST Envirement but the import encountred errors like imp-00019 row rejected due to oracle error 1
i used this command in oracle user :
imp userid=system/password file=Dump_08_2016.dmp fromuser=grhm touser=grhm ignore=y

i got this errors :

IMP-00019: row rejected due to ORACLE error 1
IMP-00003: ORACLE error 1 encountered
ORA-00001: unique constraint (GRHM.PK_H_ZONETMP) violated
Column 1 18413U
Column 2 26-JUL-2016:00:00:00
Column 3 004
Column 4 30P94
Column 5 29-JUL-2016:00:00:00
Column 6 J
Column 7 5
Column 8 SHDPHR
IMP-00019: row rejected due to ORACLE error 1
IMP-00003: ORACLE error 1 encountered
ORA-00001: unique constraint (GRHM.PK_H_ZONETMP) violated
Column 1 23056G
Column 2 30-JUL-2016:00:00:00



Regards
 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: Backup Some table
Next Topic: impdp error - bad dump file specification
Goto Forum:
  


Current Time: Sun Jan 19 21:47:08 CST 2020