ORA-02019 without .world

[suhaimi]

Hi all,
I created a db link and query a remote table. It's successful whenever I used @dbname.world but I got error ORA-02019 whenever I ommited .world from the query.
Below are the details:
create database link dbname connect to userA identified by userA using 'dbname.world';
I even try these combinations:
create... dbname.world ....using 'dbname.world'
create... dbname.world ....using 'dbname'
create... dbname ....using 'dbname'

All did not seem to work without .world

select count(*) from userA.tableA@dbname.world; -- OK
select count(*) from userA.tableA@dbname; -- return error ORA-02019.

What could be wrong ??? Please help...

Rgds,
Suhaimi

 

[sem]

Try to change your GLOBAL_NAMES parameter.

Regards, Dima

http://seminihin.narod.ru

 

[Scunningham99]

whats in your sqlnet.ora

check for
names.default_domain = world



Sy UK

 

[dbtoo2001]

When you created your dblink .world was automagically appended. If you didn't explicitly tell it the domain of the link, it assumed for you that you wanted the default from db_domain.

This is from Oracle 8i Reference manual:
If you omit domain from the name of a database link, Oracle qualifies the database link name with the domain of your local database as it currently exists in the data dictionary.

http://download-west.oracle.com/docs/cd/A87860_01/doc/server.817/a85397/statem6b.htm#2061617