Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Using two servers simultaneously
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 DBAReceived on Sat Apr 02 2005 - 04:10:02 CST