Re: connect to a remote database

Patrick,
A little misque in your example:

It should be

CREATE DATABASE LINK EXAMPLE
CONNECT TO USERNAME
IDENTIFIED BY PASSWORD
USING '(the TNSNames.ora connect string)'

Then all should be well...

hth,
John Greco
Oracle DBA/Application Developer

"Patrick Hamou" <patrick_hamou_at_hotmail.com> 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;
>
>regards,
>
>Patrick Hamou
>Oracle DBA
>patrickh_at_sympatico.ca
>
>
>
>
>zohar <zohar100_at_inter.net.il> wrote in message
>news:7uvbdq$noo$1_at_news2.inter.net.il...
>> hi there :
>>
>> how can i make a simple select statment, from several remote databases
>>
>>
>> thanks zohar
>>
>>
>

  -----------== 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 - 09:08:27 CDT