| Database Links [message #370847] |
Wed, 16 February 2000 18:47  |
Dave Skowron
Messages: 2
Registered: July 1998
|
Junior Member |
|
|
Hi,
I created a database link using the following syntax:
create database link bf connect to dskowron identified by mypassword using 'bfield'
where 'bfield' is an entry in my TNSNAMES.ORA file. The two databases are part of a local area network running Netware 5. The database versions are Oracle8 Release 8.0.3.0.6
The 'bfield' enter in the TNSNAMES.ORA file is correct - I use it to connect to that database.
The problem is when I try to query on the remote database: select * from sampledata@bf I get an error which tells me that the server cannot resolve the service name. What am I doing wrong?
Thanks,
Dave Skowron
|
|
|
|
| Re: Database Links [message #370849 is a reply to message #370847] |
Thu, 17 February 2000 04:56  |
Andreas Pollmeier
Messages: 7
Registered: February 2000
|
Junior Member |
|
|
Hi Dave!
There are two files named TNSNAMES.ORA.
One is on your client-pc and the other one is on
the oracle-server-maschine.
For using database-links, 'bfield' must be declared in the TNSNAMES.ORA on your oracle-
server-maschine.
Andreas Pollmeier
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
