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

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Sat, 26 Jul 2003 16:59:43 +0200
Message-ID: <9p55ivs93ocpe6nrpidhb19vcnor2dccf1@4ax.com>

On Sat, 26 Jul 2003 11:09:19 +0100, "Lamjed" <balamjed_at_chez.com> wrote:

>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

Perfect solution if you ever move the database from one host to another. Never use hardcoded IP addresses. Why do you think DNS and the hosts file was invented?

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Sat Jul 26 2003 - 09:59:43 CDT