Home » RDBMS Server » Enterprise Manager » connect to remote db
connect to remote db [message #68107] Fri, 15 November 2002 06:04 Go to next message
Gurdeep Singh
Messages: 64
Registered: October 2002
Member
i have two database one whose host string name= str1 and another whose host string name= deep
"str1" is local database and "deep" is remote database
i connected to str1 database as scott/tiger and want to access remote database table (t1) whose owner is user1/pete
i use the following
create database link foo connect to user1 identified by pete using 'deep';
/
database link created
select db_link from user_db_link
/
foo.world
select * from user1.t1@foo.world
/
ora-020085 : database link foo.world connect to deep

if i use
select * from user1.t1@foo
/
ora-020085 : database link foo.world connect to deep
plesase tell me what's wrong with my code
Re: connect to remote db [message #68110 is a reply to message #68107] Fri, 15 November 2002 07:04 Go to previous message
Mahesh Rajendran
Messages: 10697
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
always create a database link Name same as your connect string.
Previous Topic: best book for dba
Next Topic: ...not recognizing all the databases!
Goto Forum:
  


Current Time: Fri May 20 12:01:45 CDT 2022