OraFAQ Forum: Server Utilities

Home » RDBMS Server » Server Utilities » IMP-00017:

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

IMP-00017: [message #223152]

Wed, 07 March 2007 14:53

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

Report message to a moderator

Re: IMP-00017: [message #223157 is a reply to message #223152]

Wed, 07 March 2007 15:18

Littlefoot
Messages: 21813
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).

Report message to a moderator

Re: IMP-00017: [message #223160 is a reply to message #223157]

Wed, 07 March 2007 16:09

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..

Report message to a moderator

Re: IMP-00017: [message #223201 is a reply to message #223160]

Thu, 08 March 2007 00:02

Littlefoot
Messages: 21813
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.

Report message to a moderator

Re: IMP-00017: [message #223340 is a reply to message #223152]

Thu, 08 March 2007 08:55

Mitr
Messages: 9
Registered: January 2007

Junior Member

Thanks a lot ...it works...

Report message to a moderator

Previous Topic:	Update Remote Databases
Next Topic:	Data import

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Jul 02 16:41:07 CDT 2024