linked tables

From: Sashi <>
Date: Tue, 13 May 2008 13:54:48 -0700 (PDT)
Message-ID: <>

Is there a way of linking in a table into a DB when the table resides in another DB across a network?

For example, I have a DB, say myDB.
I'd like to be able to import data from a table in another DB, say notMyDB.
These two DB's are hosted on different servers. I see that the table is HUGE and importing the entire data into myDB wastes a lot of space.

Is it possible for me to create a 'soft link (in unix terms)' to the target table?
I'm using Oracle 9.2

Sashi Received on Tue May 13 2008 - 15:54:48 CDT

Original text of this message