Question about two oracle server exchange data automatically

hello :

  I am a new oracle programer . I am now facing such a problem :

   Our company has two oracle server connected by using TCP/IP , one server is located at a solaris host (10.10.1.3, server1) and the other a HP UX host (10.10.1.6, server2) . each server has a oracle application system installed .

   Formally , the two system operate indivually , but now the two oracle database have to exchange data with each other , means : when server1 on 10.10.1.3 received some kind of data( inserted into a table on it ) , It should immediately write these data to a buffer allocted on server2 on 10.10.1.6 , then the server2 process these data and write back . on 10.10.1.3 .

   I know that in oracle there is a method named trigger to facilite the immediate action on some database update , but I don't know how to make the application on server 10.10.1.3 to write to a buffer(table) on 10.10.1.6 ? Because I know that if I want to write some data into a database table , I must firstly login , can I set up such connection immediately after the two database startup ?
How to make the trigger know where it should write ? any smaple procedure ?

   Thank you very much and long for your help !

   Jing Shen

   Mail to: sj_at_china.pages.com.cn

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Fri May 22 1998 - 00:27:59 CDT