Re: Create a DBLINK from a Oracle 8i DB to an Oracle 7 database ?

From: Alex Ivascu <alexdivascu_at_yahoo.com>
Date: Sun, 07 Apr 2002 02:29:07 GMT
Message-ID: <T9Or8.119566$QB1.28170613@typhoon3.we.ipsvc.net>

create public database link sid_name
connect to username identified by password using 'ALIAS_FROM_YOUR_TNSNAMES';

Hope this helps.

Alex Ivascu
DBA "Nick Palmer" <nick_at_kcicorp.com> wrote in message news:uase7p4ulghjd1_at_corp.supernews.com...
> Hi all,
>
> I've got a question. Is it possible to create a dblink from an Oracle 8i
DB
> to and Oracle 7 DB, obiviously on two seperate boxes. I've tried doing it
> thru DBA Studio, but I can't seem to get it to work. Is it possible, and
if
> so, do I need to configure something in the tnsnames.ora on the 8i box, or
> use some special CREATE syntax.
>
> Thanks in advance,
> Nick.
>
>
Received on Sat Apr 06 2002 - 21:29:07 CST