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

Home -> Community -> Usenet -> c.d.o.server -> Re: Using two servers simultaneously

Re: Using two servers simultaneously

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Sat, 02 Apr 2005 12:10:02 +0200
Message-ID: <tnrs41pshia75fh228rb3qakkv904s4qvd@4ax.com>


On 1 Apr 2005 20:53:16 -0800, "kerul4u" <kerul4u_at_gmail.com> wrote:

>here is a example:
>CREATE DATABASE LINK local(*this is a link type)
> CONNECT TO emp(*this is a database name IDENTIFIED BY scott(*this is
>a user)
> USING 'tiger'(*and finally this is password);

Regrettably, this example is completely incorrect. Did you actually test it?

the syntax is
create [public] database link <linkname> connect to <username> identified by <password> using '<service name in tnsnames.ora on the server>' /

--
Sybrand Bakker, Senior Oracle DBA
Received on Sat Apr 02 2005 - 04:10:02 CST

Original text of this message

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