Home » RDBMS Server » Server Utilities » IMP-00017:
IMP-00017: [message #223152] Wed, 07 March 2007 14:53 Go to next message
Mitr
Messages: 9
Registered: January 2007
Junior Member
Hi All:

I get the below error when I use the imp utility
IMP-00017: following statement failed with ORACLE error 2264:
"ALTER TABLE "table1" ADD CONSTRAINT ""
"CHECK ENABLE NOVALIDATE"
IMP-00003: ORACLE error 2264 encountered
ORA-02264: name already used by an existing constraint

this is what I have in my export file

consistent=Y
statistics=NONE
file=
log=
tables=
userid=
query=

and this is my import file

userid=
ignore=Y
file=
log=
tables=
fromuser= touser=

Please help me...dunno where I am wrong ..
thanks a lot
Mitr
Re: IMP-00017: [message #223157 is a reply to message #223152] Wed, 07 March 2007 15:18 Go to previous messageGo to next message
Littlefoot
Messages: 20891
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
There's an existing constraint in this schema which has the same name as the one import is trying to create. As you can't change constraint name in import file, you'll have to change name of the constraint which already exists. Or, let the import fail, and later create this constraint manually (but using different name).
Re: IMP-00017: [message #223160 is a reply to message #223157] Wed, 07 March 2007 16:09 Go to previous messageGo to next message
Mitr
Messages: 9
Registered: January 2007
Junior Member
the import is successful..
it says imported successfully but with warnings..
is there any way that we can avoid the import to create the constraints...'cos the imp/exp is a repetitive process ..
dunno how the import exactly works..but it really helps if can avoid the constraint to be created ..
thank again..
Re: IMP-00017: [message #223201 is a reply to message #223160] Thu, 08 March 2007 00:02 Go to previous messageGo to next message
Littlefoot
Messages: 20891
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
For a very short solution, include CONSTRAINTS=N option into the import command line.

For a little bit longer one, at the command prompt type IMP HELP=Y and ti will show you some of possible options.

For the best result, check Export and Import utilities documentation.
Re: IMP-00017: [message #223340 is a reply to message #223152] Thu, 08 March 2007 08:55 Go to previous message
Mitr
Messages: 9
Registered: January 2007
Junior Member
Thanks a lot ...it works...
Previous Topic: Update Remote Databases
Next Topic: Data import
Goto Forum:
  


Current Time: Sun Dec 04 10:30:18 CST 2016

Total time taken to generate the page: 0.06850 seconds