imp utility [message #264164] |
Sat, 01 September 2007 06:04 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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 #264167 is a reply to message #264166] |
Sat, 01 September 2007 06:10 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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
|
|
|
|
|
Re: imp utility [message #264172 is a reply to message #264169] |
Sat, 01 September 2007 06:23 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68676 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
|
|
|