Re: Database link problem.

"Ray Teale" <ray_at_REMOVETOREPLYholly.com.au> wrote in message news:gkgn7.3253$iH4.230513_at_ozemail.com.au...
> Hi
>
> Can anybody explain why the following happens:
>
> I create a database link called HOST_A on machine 1 as
>
> 'create database link HOST_A connect to scott identified by tiger using
> 'HOST_A';
>
> When I check the DB_LINK attribute of the USER_DB_LINKS table the value is
> "HOST_A.XX.COM.AU". ie the domain name has been appended to the database
> link name.
> Everything is fine and works a treat. I drop the link 'drop database link
> HOST_A;' without a problem and recreate it again.
>
> Now on machine 2, if I create the same link and view the DB_LINK value in
> the USER_DB_LINKS table, it is named just "HOST_A"
> I can drop and recreate it the same way.
>
> The question is: what causes my environment on machine1 to append
XX.COM.AU
> to the name of the link, and not to the link on machine 2. The
tnsnames.ora
> and sqlnet.ora files on both machines are identical, I believe.
>
> Thanks for your help
>
> Ray
>
>
>
>

No versions, eh?
The behavior changed from one version to another and I don't remember when.

Regards,

Sybrand Bakker, Senior Oracle DBA Received on Mon Sep 10 2001 - 23:33:05 CDT