linked tables
From: Sashi <smalladi_at_gmail.com>
Date: Tue, 13 May 2008 13:54:48 -0700 (PDT)
Message-ID: <c6616b46-8efa-491d-8333-d22cd540b0ec@w7g2000hsa.googlegroups.com>
Date: Tue, 13 May 2008 13:54:48 -0700 (PDT)
Message-ID: <c6616b46-8efa-491d-8333-d22cd540b0ec@w7g2000hsa.googlegroups.com>
Hi,
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
Thanks,
Sashi
Received on Tue May 13 2008 - 15:54:48 CDT