Re: Acces to several database

"Ikarus" <luciver_at_teleweb.at> wrote in message news:4TEU8.128009$IR.1850001_at_news.chello.at...
> Hi!
>
> With a Database Link you can query Objects of a another Database
>
> Example:
>
> Database A will have 2 Database Links, so you query 3 Schemas like :
>
> SELECT * FROM schema.table --> Database A
> SELECT * FROM schema.table_at_Database_B --> Database B
> SELECT * FROM schema.table_at_Database_C --> Database C
>
> But you should read the Manual, that you can find for example at
> http://docs.oracle.com
>

Using your example, what we want to do is SELECT * FROM schema.table --> result from Database A + result from Database B + result From Database C
I am going to read documentation on database link to see if this correspond to what we need.

Thanks Received on Wed Jul 03 2002 - 17:55:01 CEST