Home » RDBMS Server » Server Utilities » imp ignore=y gives erorr ora-0001
imp ignore=y gives erorr ora-0001 [message #73976] Fri, 13 August 2004 03:53 Go to next message
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

Report message to a moderator

Re: imp ignore=y gives erorr ora-0001 [message #73978 is a reply to message #73976] Fri, 13 August 2004 04:56 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
there is some data already present inthe concerned, and it is throwing a violation.
you have to remove the data prior to load

Report message to a moderator

Previous Topic: importing database
Next Topic: unix variables in control file
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Jul 03 00:37:26 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.