Home » RDBMS Server » Server Utilities » insert records via dump
insert records via dump [message #187171] Fri, 11 August 2006 03:43 Go to next message
bibber
Messages: 38
Registered: August 2006
Member
Hi, I would like to know if it's possible to insert records into an existing table via a dump without deleting the records that already in that table

thnx
Re: insert records via dump [message #187190 is a reply to message #187171] Fri, 11 August 2006 04:36 Go to previous messageGo to next message
Littlefoot
Messages: 20895
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Yes, using

IMP username/password@database FILE=export.dmp IGNORE=Y

This will ignore CREATE TABLE statement (which would fail as the table(s) already exists) and insert records into the table. However, if there's UNIQUE constraint on this table, duplicate records will raise an exception.
Re: insert records via dump [message #187738 is a reply to message #187171] Tue, 15 August 2006 05:29 Go to previous messageGo to next message
bibber
Messages: 38
Registered: August 2006
Member
Can you also specify to which table in case the tablename in the dump differs from the destination table?
Re: insert records via dump [message #187773 is a reply to message #187738] Tue, 15 August 2006 10:12 Go to previous message
Littlefoot
Messages: 20895
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
If the table stored in the export (.DMP) file has a different name than the table that already exists in this user's schema, Import utility will create a brand new table and import records into it.

To import data into the existing table, it must have the same name as the one in the .dmp file.
Previous Topic: nls_numeric_characters
Next Topic: LOAD INVALID NUMBER
Goto Forum:
  


Current Time: Mon Dec 05 15:05:21 CST 2016

Total time taken to generate the page: 0.06431 seconds