Re: urgent help about export and import

In article <6ca3ao$e_at_news.microsoft.com>, "Benson Zhang" <v-acbz_at_microsoft.com> wrote:

>All new rows get into the target db, BUT all update values in existing rows
>are not updated in the target database. If I truncate target tables and do
>import, everything is fine. I am wondering that exported dump file has all
>insert statements no update statements. So the target tables' index
>rejected rows violated unique constraints and rows' values are not got
>updated.
>
>
>Benson Zhang
>angelayz_at_yahoo.com

The import function will only insert rows, there is no update option. You can write a PL*SQL routine to perform the updates. It is fairly simple with a cursor and an update loop.

HTH
   James

-- 
lorenzen_at_visi.com             | Life is complex; it has
                              |   real and imaginary parts