Database links and US.ORACLE.COM

[Aguyngueran]

Hello there

I've got two Oracle database instances on different machines,
creating database link with name TEST causes to create database link with name:
1) on the first machine TEST.US.ORACLE. COM
2) on the second machine only TEST

Why ?

Both instances have GLOBAL_NAMES set to false.

Best regards
Grzybowski Rafal

[Frank van Bortel]

Re: Database links and US.ORACLE.COM

Aguyngueran wrote:

Hello there
>
I've got two Oracle database instances on different machines,
creating database link with name TEST causes to create database link with name:
1) on the first machine TEST.US.ORACLE. COM
2) on the second machine only TEST
>
Why ?
>
Both instances have GLOBAL_NAMES set to false.
>
Best regards
Grzybowski Rafal

One has the default domain still set (us.oracle.com)

--

Regards,
Frank van Bortel

[AnaCDent]

Re: Database links and US.ORACLE.COM

Aguyngueran wrote:

Hello there
>
I've got two Oracle database instances on different machines,
creating database link with name TEST causes to create database link with name:
1) on the first machine TEST.US.ORACLE. COM
2) on the second machine only TEST
>
Why ?
>
Both instances have GLOBAL_NAMES set to false.
>
Best regards
Grzybowski Rafal

what does
SELECT * FROM GLOBAL_NAME;
display?