dB link appending

(Oracle 9i, Solaris)

When I run: CREATE PUBLIC DATABASE LINK "testdb" using 'testdb';

And then run select * from dba_db_links

OWNER Link_name
PUBLIC TESTDB.COM

Why does it put the .com on the end??

GLOBAL_NAMES=FALSE
DB_DOMAIN=WORLD
The link works!
I had to put TESTDB.COM in my server TNS!

What else could cause this?

Could you post your sqlnet.ora file?

I don't have a
/oracle/product/9.0.1/network/admin/sqlnet.ora file
or a sqlnet.ora on my client.

I turned global_names = true and explicitely created the links with

CREATE PUBLIC DATABASE LINK "testdb.world" using 'testdb';

when I run select * from [email protected] and I get:

ORA-02085 database link TESTDB.COM connect to TESTDB.COM

Check your global name by running :
SELECT * FROM GLOBAL_NAME;

SQL> SELECT * FROM GLOBAL_NAME;

TESTDB.COM

SQL> alter database rename global_name to TESTDB.WORLD;

SQL> SELECT * FROM GLOBAL_NAME;

TESTDB.WORLD


The lesson here is that changing the supposedly DYNAMIC GLOBAL_NAME is bull. You must issue the "alter database" command.


Thanks people!