| connect to remote db [message #68107] |
Fri, 15 November 2002 06:04  |
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
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
