OraFAQ Forum: Server Utilities

Home » RDBMS Server » Server Utilities » imp utility

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

imp utility [message #264164]

Sat, 01 September 2007 06:04

dirish
Messages: 232
Registered: November 2006

Senior Member

Hi,
am doing an imp using this command:

imp kwcnp/kwcnp FILE=mnswcp_user.dmp FROMUSER=MNSWCP TABLES=(WCP_EMPL_DTL) ignore=y rows=y constraints=n indexes=n LOG=import1.log[/color]
and i am getting this error:[/color]
IMP-00019: row rejected due to ORACLE error 1
IMP-00003: ORACLE error 1 encountered
ORA-00001: unique constraint (MNSWCP.PK_WCP_EMP_DTL) violated

Thank you,
Dirish

[mod-edit] color removed

[Updated on: Tue, 04 September 2007 09:07] by Moderator

Report message to a moderator

Re: imp utility [message #264166 is a reply to message #264164]

Sat, 01 September 2007 06:08

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

And what don't you understand in the error message?

Regards
Michel

Report message to a moderator

Re: imp utility [message #264167 is a reply to message #264166]

Sat, 01 September 2007 06:10

dirish
Messages: 232
Registered: November 2006

Senior Member

Hi Michel,

thanks for your prompt reply.

Can you please tell me what should I do to have these records imported.
Also, why am having this error.

THx

Report message to a moderator

Re: imp utility [message #264168 is a reply to message #264167]

Sat, 01 September 2007 06:16

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

What do you prefer?
Destroy the previous rows or keep them? Or keep both?
Only you know.
You said to Oracle I don't want duplicates and you try to insert some. Choose your way.

Regards
Michel

Report message to a moderator