Re: connect to a remote database

Actually you don't - I have several DB links that are not named anything like the global name of the actual db.....

For instance I have one named IADATA that refers to a database whose TNSnames entry is dofia.world....Works fine..

John Greco

Stephan Born <stephan.born_at_beusen.de> wrote:

>> Use Database links (if your databases are accessible from your network or
>> remote access)
>>
>> CREATE DATABASE LINK EXAMPLE
>> CONNECT TO '(the TNSNames.ora connect string)'
>> USING USERNAME
>> IDENTIFIED BY PASSWORD;
>>
>> SELECT *
>> FROM TABLE_at_EXAMPLE;
>>
>
>You have to name your DB-Link object like the global-name of the db you want
>to connect to.
>
>You get the global name with
>
>select * from global_name
>
>Regards, Stephan

  -----------== Posted via Newsfeeds.Com, Uncensored Usenet News ==----------    http://www.newsfeeds.com The Largest Usenet Servers in the World! ------== Over 73,000 Newsgroups - Including Dedicated Binaries Servers ==----- Received on Mon Oct 25 1999 - 11:55:02 CDT