You need to read your documentation on Database Links; this will allow
you to make tables accessible on other servers available from within
your PL/SQL (or other) code.
sj_at_china.pages.com.cn wrote:
>
> 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 - 11:55:12 CDT
