OraFAQ Forum: Server Utilities » Getting error at Import

Home » RDBMS Server » Server Utilities » Getting error at Import (Oracle 8i, windows 2000 server)

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

Getting error at Import [message #486675]

Sat, 18 December 2010 06:46

pokhraj_d
Messages: 117
Registered: December 2007

Senior Member

Hi,

While importing I am getting this below error.
================================================
IMP-00019: row rejected due to ORACLE error 1
IMP-00003: ORACLE error 1 encountered
ORA-00001: unique constraint (JD_HO.SYS_C001087) violated

Please help me out to resolve this issue.

Regards-
P

[Updated on: Sat, 18 December 2010 06:48]

Report message to a moderator

Re: Getting error at Import [message #486677 is a reply to message #486675]

Sat, 18 December 2010 07:05

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

>>ORA-00001: unique constraint (JD_HO.SYS_C001087) violated
Well, there is duplicate data and an unique constraint is not happy about it.
Remove the data in table before loading.

[Updated on: Sat, 18 December 2010 07:06]

Report message to a moderator

Re: Getting error at Import [message #486679 is a reply to message #486677]

Sat, 18 December 2010 07:18

pokhraj_d
Messages: 117
Registered: December 2007

Senior Member

Hi,

Could you please let me know how can I delete the data from the table as the table is not existing.

I am taking a exp dump and import the same dump to the database.

Thanks-
P

Report message to a moderator

Re: Getting error at Import [message #486680 is a reply to message #486679]

Sat, 18 December 2010 07:28

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Post your command line exp and imp statements.
Are you importing into the same database?
Or
probably the source database itself is having issue. Check that.

[Updated on: Sat, 18 December 2010 08:02]

Report message to a moderator

Previous Topic:	How to exclude public synonyms
Next Topic:	ora-01410 in export

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 23 11:43:37 CST 2024