unique key violation while importing [message #73973] |
Thu, 12 August 2004 23:22 |
rajesh
Messages: 173 Registered: November 1998
|
Senior Member |
|
|
while reimporting a schema i put ignore option = y .igot ora-0001
unique key violation.I exported the data wihtout specifying disabling constarints
or constraints = n.
how to overcome this error
|
|
|
Re: unique key violation while importing [message #73992 is a reply to message #73973] |
Mon, 16 August 2004 23:00 |
Himanshu
Messages: 457 Registered: December 2001
|
Senior Member |
|
|
Hi,
If the data already exists in your Table then you will this error but again if you have specified Ignore=Y then the import will continue & will not import the error out rows.
So,if you wish to do away with this error then either drop the table or truncate it.
HTH
Regards
Himanshu
|
|
|