Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: .world domain in database link

Re: .world domain in database link

From: change <changeme_at_changeme>
Date: Wed, 14 Aug 2002 13:41:40 -0400
Message-ID: <aje2vk$83s3@kcweb01.netnews.att.com>

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message news:ta0jluctqtr6ioqss189g4mov5kde8u1rf_at_4ax.com...
> On Tue, 13 Aug 2002 16:00:13 -0400, "change" <changeme_at_changeme>
> wrote:
>
> >Prior to Oracle 8.1.7, I created a database link "db1link", the name in
the
> >user_db_links was "db1link.world", so the suffix was automatically
provided
> >when the link was created as well when it was used.
> >
> >After upgrading to Oracle 8.1.7, I couldn't use the existing database
link
> >without explicitly providing .world suffix, and when created, the .world
was
> >not added.
> >
> > The db_domain parameter was not defined in the init file in both cases.
> >
> >Can somone tell me if there is a difference in 8.1.7 related to this.
> >
> >Maher
> >
>
> Yes. The default domain is empty now.
> You would also need to specify the domain in your tnsnames services
> ie
> db1link.world = etc
> This is of course in the release notes for 8i
>
> Hth
>
>
> Sybrand Bakker, Senior Oracle DBA
>
> To reply remove -verwijderdit from my e-mail address

First, thank you for the reply.
I still cant understand why it's working the old way in one of my system test servers that was also upgraded to 8.1.7.

PS. I'm new to news group, how do I set the post to have my name instead of "change"

Maher Received on Wed Aug 14 2002 - 12:41:40 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US