Home » RDBMS Server » Server Utilities » imp utility
imp utility [message #264164] Sat, 01 September 2007 06:04 Go to next message
dirish
Messages: 205
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 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
And what don't you understand in the error message?

Regards
Michel
Re: imp utility [message #264167 is a reply to message #264166] Sat, 01 September 2007 06:10 Go to previous messageGo to next message
dirish
Messages: 205
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
Re: imp utility [message #264168 is a reply to message #264167] Sat, 01 September 2007 06:16 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: imp utility [message #264169 is a reply to message #264168] Sat, 01 September 2007 06:19 Go to previous messageGo to next message
dirish
Messages: 205
Registered: November 2006
Senior Member
I want the previous records
Re: imp utility [message #264172 is a reply to message #264169] Sat, 01 September 2007 06:23 Go to previous message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
So you have nothing to do this is what Oracle did but he warned you.

Regards
Michel
Previous Topic: How to craete dump file of tablespace
Next Topic: Export only part of data.............
Goto Forum:
  


Current Time: Mon Dec 05 14:59:41 CST 2016

Total time taken to generate the page: 0.08483 seconds