Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: connect to a remote database

Re: connect to a remote database

From: Patrick Hamou <patrick_hamou_at_hotmail.com>
Date: Sun, 24 Oct 1999 21:56:19 GMT
Message-ID: <7gLQ3.23073$Jp4.37912@news20.bellglobal.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US