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

Report message to a moderator

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

Report message to a moderator

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?

Report message to a moderator

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

Report message to a moderator

Previous Topic: nls_numeric_characters
Next Topic: LOAD INVALID NUMBER
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Dec 26 00:15:31 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.