Re: Query accross database boundaries

From: andrew_webby at hotmail <spam_at_no.thanks.com>
Date: Mon, 11 Jun 2001 16:03:46 +0100
Message-ID: <992271872.29986.0.nnrp-08.c30bdde2@news.demon.co.uk>

Why do you need to use snapshots etc?

Will a database link not do just as well? In case you don't know, a "create database link" will allow you to do "select a.x,b.y from a, b_at_otherdatabase where a.x = b.y etc..."

"Jochen Kalmbach" <nospam-Jochen.Kalmbach_at_holzma.de> wrote in message news:9g21f5$60e$05$1_at_news.t-online.com...
> Hello,
>
> is it possible to create a query accross database boundaries ?
> e.g. make a union from tables in two different databases on the same
server
> ?
>
> Another question:
> What replication machanism a implemented in Oracle (e.g. snapshot,
> transactional, merge, ...)
>
>
> Or is there a good document which explains all features of the Oracle
server
> ???
>
>
> Greetings
> Jochen
>
>
Received on Mon Jun 11 2001 - 10:03:46 CDT