Re: Can i change the IP Adresse of a public database link ?

From: cf <news_at_sitinfo.com>
Date: Tue, 18 Jun 2002 19:22:45 +0200
Message-ID: <3d0f6c66$0$199$4d4eb98e@read.news.fr.uu.net>

select owner,db_link,host from all_db_links;

PUBLIC
CF.WORLD
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.100.3.2)(PORT=1521))(CONNECT_DA TA=(SERVICE_NAME=cf)))

In my tnsname IP 10.100.2.1
Regards

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> a écrit dans le message de news: kaqugukgefrt5cs1pvsmeorlig3pfvim0a_at_4ax.com...
> On Tue, 18 Jun 2002 15:58:52 +0200, "cf" <news_at_sitinfo.com> wrote:
>
> >Can i change the IP Adresse of a public database link ?
> >
> >The public database link is use in oracle replication.
> >
> >Thanks in Advance..
> >With My Best Regards...
> >Christophe
> >
> >
> Question: does a database link have an IP-address.
> Answer : a database link is a *logical* connection not a physical one
> Question: did you use the hardcoded IP-address in your host= section
> when defining the service.
> You now know why that was plain stupid.
>
> Regards
>
>
> Sybrand Bakker, Senior Oracle DBA
>
> To reply remove -verwijderdit from my e-mail address
Received on Tue Jun 18 2002 - 12:22:45 CDT