Re: Cross database joins in Oracle 8.0

From: Jonathan Gennick <jonathan_at_gennick.com>
Date: 2000/05/23
Message-ID: <31slisc8qd7obic0kbg9rj1ea0t3kgeu4v@4ax.com>#1/1

On Tue, 23 May 2000 16:38:28 GMT, acf4cga_at_my-deja.com wrote:

>I know how to this in SQL Server 7.0 using the
>databasename.username.tablename syntax.
>Does anyone know how to do this in Oracle?

You could do this using a database link. Look up the CREATE DATABASE LINK command in your SQL Reference manual. Before you can create a link, you need a net service name (tnsnames) defined for each database.

Jonathan

---

jonathan_at_gennick.com
http://gennick.com
Brighten the Corner Where You Are Received on Tue May 23 2000 - 00:00:00 CDT