Home » RDBMS Server » Server Administration » Database Links
Database Links [message #370847] Wed, 16 February 2000 18:47 Go to next message
Dave Skowron
Messages: 2
Registered: July 1998
Junior Member

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

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?

Dave Skowron
Re: Database Links [message #370849 is a reply to message #370847] Thu, 17 February 2000 04:56 Go to previous message
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-

Andreas Pollmeier
Previous Topic: A SQL Challenge
Next Topic: help again
Goto Forum:

Current Time: Sun May 26 20:15:37 CDT 2024