Xref: alice comp.databases.oracle.misc:30066 Path: alice!news-feed.fnsi.net!news.idt.net!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!nntp2.dejanews.com!nnrp1.dejanews.com!not-for-mail From: Rich Goldkamp Newsgroups: comp.databases.oracle.misc Subject: Re: Remote database......sort of Date: Wed, 28 Apr 1999 19:14:16 GMT Organization: Deja News - The Leader in Internet Discussion Lines: 49 Message-ID: <7g7mlq$m2i$1@nnrp1.dejanews.com> References: <7g57mn$fgb$1@nnrp1.dejanews.com> <37271f45.0@news.cadvision.com> To: art_merar@my-dejanews.com X-Article-Creation-Date: Wed Apr 28 19:14:16 1999 GMT X-Http-User-Agent: Mozilla/4.0 (compatible; MSIE 4.01; Windows NT) X-Http-Proxy: 1.1 x5.dejanews.com:80 (Squid/1.1.22) for client 209.163.191.126 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@news.cadvision.com>, "Terry Dykstra" wrote: > You need to create a database link. It can point to any database, including > itself. > > -- > Terry Dykstra > Canadian Forest Oil Ltd. > art_merar@my-dejanews.com wrote in message > <7g57mn$fgb$1@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@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