OraFAQ Forum: Server Utilities

Home » RDBMS Server » Server Utilities » Import

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

Import [message #70177]

Thu, 25 April 2002 02:47

Micky
Messages: 18
Registered: January 2002

Junior Member

I was wondering I ran a import and it failed on some objects. I resolve the reason why it failed on these
now if i put in my parameter file ignore=n and rerun it will my import fail and not insert on the already created objects and continue creating the previous uncreated objects.

Report message to a moderator

Re: Import [message #70179 is a reply to message #70177]

Thu, 25 April 2002 06:17

Cindy
Messages: 88
Registered: November 1999

Member

Set ignore=Y

This should resolve your problem if I understand your question correctly.

Report message to a moderator

Re: Import [message #70182 is a reply to message #70177]

Thu, 25 April 2002 07:30

Cindy
Messages: 88
Registered: November 1999

Member

Yes, however it only cause duplicate rows if one or more columns of the table are NOT specified with the UNIQUE integrity constraint.

My suggestion is import the data into database first and if duplicate records do happened, just clean it out later.

remove duplicate values:
http://www.orafaq.net/faqsql.htm#ONLOGON

Unless someone else other there have a better suggestion.

Report message to a moderator

UNSUBSCRIBE [message #70184 is a reply to message #70177]

Thu, 25 April 2002 21:29

Olcay Yenilmez
Messages: 2
Registered: April 2002

Junior Member

UNSUBSCRIBE

Report message to a moderator

Previous Topic:	Oracle 9i
Next Topic:	ORA-05901 error message

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 08:03:14 CDT 2024