Re: linking dbases on same machine

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 Received on Tue May 07 2002 - 14:48:21 CDT