Home » RDBMS Server » Server Utilities » Getting error at Import (Oracle 8i, windows 2000 server)
Getting error at Import [message #486675] Sat, 18 December 2010 06:46 Go to next message
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 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
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 Go to previous messageGo to next message
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
Re: Getting error at Import [message #486680 is a reply to message #486679] Sat, 18 December 2010 07:28 Go to previous message
Mahesh Rajendran
Messages: 10707
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:
  


Current Time: Fri Mar 29 01:54:53 CDT 2024