| Export-import [message #63857] |
Wed, 17 November 2004 04:06  |
Dik
Messages: 27
Registered: June 2002
|
Junior Member |
|
|
HI,
How can I import, load data from one table(customer) to another table(partner). The second one is not empty, records should be inserted or updated. I have *.dmp file of first table:
Thanks
|
|
|
|
| Re: Export-import [message #63859 is a reply to message #63857] |
Wed, 17 November 2004 06:53  |
andrew again
Messages: 2577
Registered: March 2000
|
Senior Member |
|
|
|
you need to import customer into a staging table customer. You can do that into the target schema if you don't already have such a customer table else you need a different schema. Use 2 sql statements to do the insert/update.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
