Re: Where is the object (DBLINK) suffix come from?

From: Lamjed <balamjed_at_chez.com>
Date: Sat, 26 Jul 2003 11:09:19 +0100
Message-ID: <bftjuq$ib27g$1@ID-127366.news.uni-berlin.de>

hi,
i have the same probleme , my solution is : create database link Mylinkname connect to MynameUser identified by Mypassword using '(DESCRIPTION=(ADDRESS= (PROTOCOL=tcp)(HOST=x.x.x.x)(PORT=y))(CONNECT_DATA=(SID=MySID)))'

exemple of my use:

select Orders_Num from Orders_at_Mylinkname where Orders_Date
>to_date('01/01/2003');

Lamjed

"Kin Ng" <kin_ng5_at_yahoo.com> a écrit dans le message news: d5b3f600.0307241113.43baa05a_at_posting.google.com...
> When I created a DBLINK, I got US.ORACLE.COM attached to the end of
> the dblink name. Where is this suffix come from and how can I get rid
> of it?
>
> Thanks for any help.
Received on Sat Jul 26 2003 - 05:09:19 CDT