Re: Database links question

From: Syltrem <syltrem_at_videotron.ca>
Date: 2000/06/09
Message-ID: <nHc05.2$z4.317@weber.videotron.net>#1/1

create database link dbname connect to username identified by password using 'dbname.world';
Select * from table_at_dbname;

dbname in that command must be the same as the other database. In my case, anyway, if I give the dblink a name different than my database name, Oracle complains (I don't know why that is).

You can connect to any database/user you like if you have the correct tnsnames.ora definitions to get to the db, and correct pwd for the user.

Have fun!

Boo <Boo_at_yahoo.com> wrote in message news:3941480B.5F7034D4_at_yahoo.com...
> Running Oracle 8.0.6 on Solaris 2.7
>
> We have a couple of databases set up on two different servers and will
> need to set up advanced replication between these two servers.
> The two databases do have different database names, but the same
> schemas.
> I haven't been able to determine 100%, through the documentation,
> whether it's possible to set up a database link, but my thoughts are
> that
> only between two databases with the same name is it possible.
>
> Can someone clarify?
>
> TIA
>
Received on Fri Jun 09 2000 - 00:00:00 CDT