Re: How can I join 2 databases?

From: Kristof Vermeire <sloefex_at_nospam.hotmail.com>
Date: Fri, 23 Mar 2001 14:27:48 GMT
Message-ID: <E3Ju6.44$ef7.3382@nreader1.kpnqwest.net>

Depends ... if he means 2 different instances on the same machine, he doesn't need dblink ...

"Mark Townsend" <markbtownsend_at_home.com> wrote in message news:B6CD8E28.4A14%markbtownsend_at_home.com...
> Client side joins should be avoided - they are simply too expensive in
that
> all data needs to be sent across the network no matter how many rows
> actually appear in the final result set. Instead, use a dblink in 1
database
> so that you can access the data in the other database. On 8.0.5 you will
see
> some optimization of the join across the dblink, and even more so on
> Oracle8i.
>
> > From: "Ron" <ronyin_at_tpts5.seed.net.tw>
> > Organization: DCI HiNet
> > Newsgroups: comp.databases.oracle.server
> > Date: Thu, 8 Mar 2001 13:18:17 +0800
> > Subject: How can I join 2 databases?
> >
> > i'm using oracle8.0.5 on RS6000?
> > how can i join 2 tables from 2 databases by using client applications(VB
or
> > Java)?
> >
> > Ron
> >
> >
>
Received on Fri Mar 23 2001 - 08:27:48 CST