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

In addition to the database link, you'll also need the "distributed" option installed on both databases. Does anyone know if Personal Oracle has the distributed option available???

Rich

In article <37271f45.0_at_news.cadvision.com>,   "Terry Dykstra" <tdykstra_at_cfol.ab.ca> wrote:
> 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
>
>

--

Rich Goldkamp, Consultant, OCP		RJGoldka_at_dcss.com
Digital Consulting & Software Services	(504) 523-5005 x2736

-----------== Posted via Deja News, The Discussion Network ==----------
http://www.dejanews.com/       Search, Read, Discuss, or Start Your Own