Re: Exchange database between two databases

jamesyang_at_163.net (James) wrote in message news:<86815f22.0111261914.11491aa_at_posting.google.com>...
> We wanna use two oracle DB based applications (small ERP) and there
> are a lots of data need to be exchaged between them. We have some
> solutions for it but I wnat to know:
>
> 1)Database link
> * Does it support two instances on the two physical servers?
> * Will it cause problems to other DB such as dead lock?
> * Will it decrease the system performance?
>

If you have the distrubed option and/or Enterprise edition then using database links on both systems and sending data back and forth is pretty straight forward; however, what kind of problems you encounter will depend on how your application works and how you use the links. You can use the links in triggers on a per record basis tying the two systems together, with replication, and to perform remote DML in your pl/sql, sqlplus, and pro*C code and the problems you encounter will depend on quanity of data and how many users are updating the source and target objects as your code runs.  

> 2)export to a file then import it in the other DB (some ERP dislike
> write the table direcly)
> * Is it easy to manage the files?
> * Other issue?

Data transfer file management is not that difficult to accomplish. You will have bigger issues with how to process the files: what to do when duplicates are encountered, error handling, and so on. In general extracting delimited or fixed format files and using sqlldr or programs to process the data provides more processing flexibility than exp/imp.

> jamesyang_at_163.net

• Mark D Powell --