OraFAQ Forum: Server Utilities » datapump impdb error

Home » RDBMS Server » Server Utilities » datapump impdb error (oracle 10g)

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

datapump impdb error [message #342080]

Thu, 21 August 2008 05:12

seema.taunk
Messages: 96
Registered: October 2006

Member

Dear all,

When I import using impdb command & some data exists in the table, then impdb fails. It don't insert remaining records in table. In oracle 9i , we have option ignore=Y , so when we insert duplicate data, it gives error but insert remaining rows. But in case of impdb command, which parameter we have to use so that remaining rows will get inserted.

Thnaks

Report message to a moderator

Re: datapump impdb error [message #342081 is a reply to message #342080]

Thu, 21 August 2008 05:14

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

Quote:

TABLE_EXISTS_ACTION
Action to take if imported object already exists.
Valid keywords: (SKIP), APPEND, REPLACE and TRUNCATE.

Report message to a moderator

Re: datapump impdb error [message #342084 is a reply to message #342081]

Thu, 21 August 2008 05:20

seema.taunk
Messages: 96
Registered: October 2006

Member

Thanks. So if I use SKIP option, will it skip entire table or duplicate rows & insert non duplicate rows?

Report message to a moderator

Re: datapump impdb error [message #342087 is a reply to message #342084]

Thu, 21 August 2008 05:24

Michel Cadot
Messages: 68650
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Utilities

Regards
Michel

Report message to a moderator

Re: datapump impdb error [message #342090 is a reply to message #342087]

Thu, 21 August 2008 05:29

seema.taunk
Messages: 96
Registered: October 2006

Member

I have already read that. But I am confused . Will it ignore entire table or duplicate rows? & insert non dupliacte rows.

Report message to a moderator

Re: datapump impdb error [message #342094 is a reply to message #342080]

Thu, 21 August 2008 05:44

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

Ignores entire table.

Report message to a moderator

Re: datapump impdb error [message #342127 is a reply to message #342090]

Thu, 21 August 2008 07:50

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

You didn't read properly.

TABLE_EXISTS_ACTION
Default: SKIP (Note that if CONTENT=DATA_ONLY is specified, the default is APPEND, not SKIP.)

Purpose

Tells Import what to do if the table it is trying to create already exists.

Syntax and Description

TABLE_EXISTS_ACTION={SKIP | APPEND | TRUNCATE | REPLACE}

The possible values have the following effects:

SKIP leaves the table as is and moves on to the next object. This is not a valid option if the CONTENT parameter is set to DATA_ONLY.

APPEND loads rows from the source and leaves existing rows unchanged.

TRUNCATE deletes existing rows and then loads rows from the source.

REPLACE drops the existing table and then creates and loads it from the source. This is not a valid option if the CONTENT parameter is set to DATA_ONLY.

Report message to a moderator

Re: datapump impdb error [message #342291 is a reply to message #342127]

Thu, 21 August 2008 23:30

seema.taunk
Messages: 96
Registered: October 2006

Member

Hi,

Thanks for your reply. Actually I want to insert 1 crore records (may contain duplicate data)in table of approx. 100 crore records. I don't want to disable constraint & then then import duplicate rows & then delete duplicate records from entire table. So which is the best method to do this?

Report message to a moderator