Home » RDBMS Server » Server Utilities » datapump impdb error (oracle 10g)
datapump impdb error [message #342080] Thu, 21 August 2008 05:12 Go to next message
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
Re: datapump impdb error [message #342081 is a reply to message #342080] Thu, 21 August 2008 05:14 Go to previous messageGo to next message
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.

Re: datapump impdb error [message #342084 is a reply to message #342081] Thu, 21 August 2008 05:20 Go to previous messageGo to next message
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?
Re: datapump impdb error [message #342087 is a reply to message #342084] Thu, 21 August 2008 05:24 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Utilities ./fa/1622/0/

Regards
Michel
Re: datapump impdb error [message #342090 is a reply to message #342087] Thu, 21 August 2008 05:29 Go to previous messageGo to next message
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.
Re: datapump impdb error [message #342094 is a reply to message #342080] Thu, 21 August 2008 05:44 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Ignores entire table.
Re: datapump impdb error [message #342127 is a reply to message #342090] Thu, 21 August 2008 07:50 Go to previous messageGo to next message
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.

Re: datapump impdb error [message #342291 is a reply to message #342127] Thu, 21 August 2008 23:30 Go to previous messageGo to next message
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?
Re: datapump impdb error [message #342295 is a reply to message #342080] Thu, 21 August 2008 23:38 Go to previous messageGo to next message
BlackSwan
Messages: 25036
Registered: January 2009
Location: SoCal
Senior Member
I want to teach my pig to fly.
So which is the best method to do this?
Re: datapump impdb error [message #342311 is a reply to message #342291] Fri, 22 August 2008 00:22 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You can't do it with impdp (subject of this topic).
Now if you have a new question, create a new topic, in the appropriate forum.

Regards
Michel
Re: datapump impdb error [message #342332 is a reply to message #342311] Fri, 22 August 2008 01:21 Go to previous message
seema.taunk
Messages: 96
Registered: October 2006
Member
Ok thanks
Previous Topic: Error while doing an expdp for a large datafile
Next Topic: How to covert the scientific format value into number or text in oracle
Goto Forum:
  


Current Time: Sun Dec 04 06:48:02 CST 2016

Total time taken to generate the page: 0.14505 seconds