Re: Tables from different databases

From: Brian Peasland <peasland_at_edcmail.cr.usgs.gov>
Date: Tue, 19 Oct 1999 13:01:32 GMT
Message-ID: <380C6BAC.66931103@edcmail.cr.usgs.gov>

You have to create a database link to the other database. If the link is called "dblink", then you can reference the remote table by:

SELECT * FROM table_at_dblink;

HTH,
Brian

Leonardo Kenji Shikida wrote:
>
> Is it easy to refer to tables from different databases in a query like
> db2's Data Joiner in Oracle 8i ?
>
> Please, answer by email if possible.
>
> Thanks in Advance
>
> K
> ______________________________________________________________________________
> Leonardo Kenji Shikida ................ Graduado em Ciencia da Computacao/UFMG
> http://www.dcc.ufmg.br/~kenji .............................. kenji@dcc.ufmg.br
> ------------------------------------------------------------------------------
Received on Tue Oct 19 1999 - 08:01:32 CDT