Re: Remote database......sort of

I don't know much about Personal Oracle. However, here are steps that you'll need to setup the parallel record processing:

1) create a db_link for both databases, each pointed to one another.
2) create a trigger as you already know.
3) change the TNSNAMES.ORA & LISTENER.ORA on both servers

    to listen & resolve the SID.
You can try this on P-Oracle and let me know the result.

art_merar_at_my-dejanews.com wrote in message <7g57mn$fgb$1_at_nnrp1.dejanews.com>...
>
>
>Hello,
>
>We will be creating a trigger to send records to another Oracle database on
>our network. I assume that I will need to change the tnsnames.ora file.
The
>machine will not be in place for at least 3 weeeks.
>
>In the mean time, I was to install Personal Oracle on a PC hooked up on the
>hub. I am hoping to simulate the 'sending records' process. This will
work
>right? Since that PC will have an IP address, I should be able to set it up
>in the tnsnames.ora file as another database right?
>
>Please let me know if I am missing something.
>
>Send a copy to my e-mail......
>
>Thanks,
>
>Arthur
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Sat May 01 1999 - 08:31:48 CDT