insert records via dump [message #187171] |
Fri, 11 August 2006 03:43 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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 #187773 is a reply to message #187738] |
Tue, 15 August 2006 10:12 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/72104.gif) |
Littlefoot
Messages: 21813 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.
|
|
|