var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Issue with the database link
I want to access the abc table in the "nav" database from the "avi"database.
nav- is the database where the abc table is present.
avi- current database
this command is run in the avi database.
SQL> Create Database Link nav.nav.domian using 'nav' ;
Database link created.
SQL> select * from firstname.lastname@example.org;
select * from email@example.com
ERROR at line 1:
ORA-02085: database link NAV.NAV.DOMIAN connects to NAV.DOMAIN
It appears that you are using global_names. In this case, the link name must match the target database name.
Here is a clip from the oracle docs
'...The value of the GLOBAL_NAMES initialization parameter determines whether the database link must have the same name as the database to which it connects. '
Create Database Link nav using 'nav' ;
The error is saying that the remote db's name is nav, so you can either let oracle fully qualify it for you, or you can do it yourself.
create database link nav.domain using 'nav';
Hope this helps.