Re: Acces to several database
From: Mike Alba <mike_at_netplasma.com>
Date: Wed, 03 Jul 2002 17:01:39 GMT
Message-ID: <3D232DED.6080900_at_netplasma.com>
>>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
>>
>>
Date: Wed, 03 Jul 2002 17:01:39 GMT
Message-ID: <3D232DED.6080900_at_netplasma.com>
Is it a correct assumption that these will
all be Oracle databases? Or will have
have multiple types of datasources?
Antoine GOURAUD wrote:
> "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 - 19:01:39 CEST