Re: linking dbases on same machine

Daniel Morgan <dmorgan_at_exesolutions.com> wrote in message news:<3CD82F7D.F91305BD_at_exesolutions.com>...
> TurkBear wrote:
>
> > Should work fine..
> > Each instance is totally ignorant of where the any other is physically located,
> > so, as long as the tnsnames.ora file on the server has the needed info, that type of db link is like any other...
> >
> > tim.bedford_at_ttplabtech.com (Tim) wrote:
> >
> > >Hi,
> > >
> > >Is it possible to create a database link to a between two database
> > >instances running on the same machine?
> > >thanks,
> > >
> > >Tim
> >
> > -----------== Posted via Newsgroups.Com - Uncensored Usenet News ==----------
> > http://www.newsgroups.com The #1 Newsgroup Service in the World!
> > -----= Over 100,000 Newsgroups - Ulimited Fast Downloads - 19 Servers =-----
>
> It is even better than that.
>
> You can link an instance to itself. Just put another entry into the TNSNAMES.ORA. I do this in class to teach
> students how to create database links on their own machine. Database links connect based on the tnsnames.ora entry.
> They are not intelligent enough to know, or care, that what they connect to is themselves.
>
> Daniel Morgan

Thanks very much, I never thought of thought, solves all kinds of problems.

Tim Received on Wed May 08 2002 - 04:34:15 CDT