Problem in Database link [message #369674] |
Sat, 25 March 2000 07:16 |
N.Suresh
Messages: 3 Registered: March 2000
|
Junior Member |
|
|
Hello,
This is N.Suresh.
Can u any one help me. please go through the following and solve me the problem.
I have installed Oracle-8 Personal in my system(A).
And I have installed oracle 8i in another server(B).
I configured to access the Oracle 8i database(B) to my system(A) using net8 easy configuration.
I have given the Service name as Oracle8i.I am able to connect with oracle8i
database(B) from my system(A) like connect scott/tiger@oracle8i.
So i am able to access the 8i database tables from my machine(A).
Similarly I configured to access the Oracle8 Personal database(A) to Oracle 8i server(B)
using net8 easy configuration.
I have given the Service name as Oracle8.I am able to connect with oracle8 personal
database(A) from oracle 8i server(B) like connect scott/tiger@oracle8.
So i am able to access the 8(personal) tables from machine(B).
Then I created a database link in Oracle 8i server(A) to Personal Oracle(A).
Syntex;
SQL> Create Database link Oracle8 connect to scott identified by tiger
2 using 'ORACLE8';
Database link created.
After that i tried to access the rows from Personal Oracle 8(A).
The following error is comming.
SQL> Select * from emp@ORACLE8;
Select * from emp@ORACLE8
*
ERROR at line 1:
ORA-02085: database link ORACLE8 connects to ORACLE.WORLD
Similarly I created a database link from Personal Oracle8 (A) to Oracle 8i server(B).
SQL> Create Database link Oracle8i connect to scott identified by tiger
2 using 'ORACLE8I';
Database link created.
The same error comming for this link also.
This following is the error
************************************************************************************************
ORA-02085 database link string connects to string
Cause: The database link attempted to connect to a database with a different name.
The name of the database link must be the same name as the name of the database.
Action: Create a database link with the same name as the database to which it connects.
************************************************************************************************
Reagrds
N.Suresh
|
|
|