| db link [message #49864] |
Thu, 14 February 2002 11:39  |
Richard
Messages: 44
Registered: May 2000
|
Member |
|
|
Hi, experts:
I created a database link, but I couldn't access the remote database (table) by:
select * from mytable@mydb;
Do I have to do something else in order to access the table in other database?
Thanks
rich
|
|
|
|
|
|
| Re: db link [message #49880 is a reply to message #49864] |
Fri, 15 February 2002 04:40  |
Richard
Messages: 44
Registered: May 2000
|
Member |
|
|
Grant:
Thank u. I did have an entry in my tnsnames.ora file like:
MYDB.MYSVR.MYCOMP.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCLE = TCP)
(HOST = MYDB.MYSVR.MYCOMP.COM)
(PORT = 1521)
)
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = MYDB.MYSVR.MYCOMP.COM)
)
)
There must be something wrong with my configuration. But I don't know where. would you please give me a guide again?
Thank you.
richard
|
|
|
|
|
|
| Re: db link [message #49891 is a reply to message #49884] |
Fri, 15 February 2002 09:19 |
ricahrd
Messages: 4
Registered: February 2002
|
Junior Member |
|
|
Grant:
my sqlnet.ora file is very simple:
NAMES.DIRECTOR_PATH= (TNSNAMES, ONAMES, HOSTNAME)
i don't known how to deal with this file. pls help me.
thanks
richard
|
|
|
|
| Re: db link [message #49961 is a reply to message #49864] |
Wed, 20 February 2002 17:31 |
chitlenz
Messages: 1
Registered: February 2002
|
Junior Member |
|
|
Try setting your /etc/hosts filer to point to the offending server.
-Hope that helps - Chit
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
