Untitled

create database link ats_ora connect using <username> identified by <password> using ‘<dblink name>’;

place the target database tns entry in source database.

Accessing the dblink,

we should be able to accessing the dblink using both the names as below.

select * from dual@ats_ora;

select * from dual@ats_ora.world;


Error:


dblink name is expected.


to fix the issue we have to change the global database name.

alter database rename global_name to <dbname.world>;

Then it will work:

select * from dual@ats_ora;

select * from dual@ats_ora.world;