Re: .world domain in database link

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Wed, 14 Aug 2002 00:01:19 +0200
Message-ID: <ta0jluctqtr6ioqss189g4mov5kde8u1rf@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 Received on Tue Aug 13 2002 - 17:01:19 CDT