urgent help about export and import

Hi,

I have encountered a problem with export import util. in Oracle 8 on NT.

I have a source and a target dbs.

1. export from the source db and import into target one.
2. update some fields' value of existing rows and insert new rows in the source db
3. have another export from source db and import into the target db.

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.

Tried the following

1)  8.0.3 without newest patch
2)  8.0.3 with the newest patch updates
3)  8.0.4

All have the same problem.

What should I do? Do I need to set up some specific parameter to make the import doing the update.

Your help is appreciated

Benson Zhang
angelayz_at_yahoo.com Received on Mon Feb 16 1998 - 00:00:00 CST