OraFAQ Forum: Server Utilities

Home » RDBMS Server » Server Utilities » Import ERROR (Oracle Database 10g Enterprise Edition , 10.2.0.4.0,Linux64_86)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Import ERROR [message #654799]

Sat, 13 August 2016 09:49

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

Report message to a moderator

[Message index]

		Import ERROR By: abdo2203 on Sat, 13 August 2016 09:49
		Re: Import ERROR By: John Watson on Sat, 13 August 2016 09:52
		Re: Import ERROR By: abdo2203 on Sat, 13 August 2016 10:06
		Re: Import ERROR By: Michel Cadot on Sat, 13 August 2016 10:16
		Re: Import ERROR By: abdo2203 on Sat, 13 August 2016 10:22
		Re: Import ERROR By: abdo2203 on Sat, 13 August 2016 10:25
		Re: Import ERROR By: Michel Cadot on Sat, 13 August 2016 10:30
		Re: Import ERROR By: abdo2203 on Sat, 13 August 2016 10:38
		Re: Import ERROR By: Michel Cadot on Sat, 13 August 2016 10:40
		Re: Import ERROR By: abdo2203 on Sat, 13 August 2016 10:44
		Re: Import ERROR By: Michel Cadot on Sat, 13 August 2016 10:50
		Re: Import ERROR By: abdo2203 on Sun, 14 August 2016 11:15
		Re: Import ERROR By: Michel Cadot on Sun, 14 August 2016 11:23
		Re: Import ERROR By: John Watson on Sun, 14 August 2016 11:58
		Re: Import ERROR By: Michel Cadot on Sun, 14 August 2016 12:31
		Re: Import ERROR By: abdo2203 on Mon, 15 August 2016 11:51
		Re: Import ERROR By: Michel Cadot on Mon, 15 August 2016 12:11
		Re: Import ERROR By: abdo2203 on Mon, 15 August 2016 12:26
		Re: Import ERROR By: Michel Cadot on Mon, 15 August 2016 12:31
		Re: Import ERROR By: BlackSwan on Mon, 15 August 2016 12:40
		Re: Import ERROR By: abdo2203 on Mon, 15 August 2016 12:40
		Re: Import ERROR By: Michel Cadot on Mon, 15 August 2016 12:46
		Re: Import ERROR By: abdo2203 on Mon, 15 August 2016 12:59
		Re: Import ERROR By: Michel Cadot on Mon, 15 August 2016 13:32
		Re: Import ERROR By: EdStevens on Tue, 16 August 2016 06:34
		Re: Import ERROR By: BlackSwan on Sat, 13 August 2016 10:27
		Re: Import ERROR By: Michel Cadot on Sat, 13 August 2016 10:03

Previous Topic:	Backup Some table
Next Topic:	impdp error - bad dump file specification

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 26 05:52:06 CDT 2024