| Importing Database problem [message #73921] |
Tue, 03 August 2004 06:48  |
mani
Messages: 105
Registered: September 1999
|
Senior Member |
|
|
I have a database dump file of oracle V08.01.07.I tried import the dmp file into oracle Release 9.2.0.1.0.That time I am getting the following error
IMP-00019: row rejected due to ORACLE error 1
IMP-00003: ORACLE error 1 encountered
ORA-00001: unique constraint (Scott.Testtable) violate
How do resolve the problem?
Anybody help ASAP.
|
|
|
|
| Re: Importing Database problem [message #73931 is a reply to message #73921] |
Wed, 04 August 2004 04:45  |
Himanshu
Messages: 457
Registered: December 2001
|
Senior Member |
|
|
Hi,
This is due to the fact that you have TESTTABLE already present in your Database which already has the rows present in it which you are trying to import.
Either Drop this Table from SCOTT schema or import your Dump file using parameter ignore=Y.
HTH
Regards
Himanshu
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
