Home » RDBMS Server » Enterprise Manager » help to me
help to me [message #68282] Wed, 05 March 2003 22:55 Go to next message
Messages: 2
Registered: March 2003
Junior Member
1* create public database link hr_link connect to scott identified by tiger using 'orcl'
SQL> /

Database link created.

SQL> select * from emp@hr_link;
select * from emp@hr_link
ERROR at line 1:
ORA-02085: database link HR_LINK.US.ORACLE.COM connects to DATA.US.ORACLE.COM
Re: help to me [message #68283 is a reply to message #68282] Thu, 06 March 2003 06:12 Go to previous message
Mahesh Rajendran
Messages: 10697
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
1. first make sure ur tnsconnectString 'orcl' is working fine.. by testing through sqlplus.
2. convention is to create a dblink with same Name as
   connect string.
3. and
You have to set global_names to false. did u do that?

SQL>ALTER SESSION SET global_names = false; 

You can also set this in initSID.ora. 

Previous Topic: backup/recovery plan for remote database
Next Topic: Solution to DBA Problem
Goto Forum:

Current Time: Sun May 22 23:36:24 CDT 2022