You need to create a database link. It can point to any database, including
itself.
--
Terry Dykstra
Canadian Forest Oil Ltd.
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 Wed Apr 28 1999 - 09:47:47 CDT
