I'm not sure what your question is here. If you want to keep old rows in one site and add new rows from another site, then export/import probably doesn't work the best. You can either employ Advanced Replication to replicate the data from one site to another. Or, you can move the data from one site to another through a database link. This can be automated with triggers or Materialized Views. If you choose to export/import, then you may not be able to import directly into the destination table. You may have to import into a staging table and the move the data over with DML commands.
Dig Deeper on Oracle database design and architecture
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.