Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: connect to a remote database
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
>
>
Received on Sun Oct 24 1999 - 16:56:19 CDT