Re: linked tables

"Sashi" <smalladi_at_gmail.com> wrote in message news:c6616b46-8efa-491d-8333-d22cd540b0ec_at_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

Lookup CREATE DATABASE LINK command.

-- 
Terry Dykstra