that works as long as you can live with possibly inconsistent data in
the joint table due to either
- updates to the employee data on either site during the day not
reflected in the joint table until the nightly processing is done
- nightly process failing and data in the joint table either
non-existent or wrong
- אדר_יחיאל <adary_at_mehish.co.il> wrote:
> Hello Srini
>
> We had a case like this where one of the tables was in a database
> that
> reside in a remote site.
> Our solution was to create a table that combine employees tables from
> 2 site
> into one TABLE in the local site.
>
> This way the select and join is done ONCE at night.
>
> Yechiel Adar, Mehish Computer Services
> adary_at_mehish.co.il
>
> > -----Original Message-----
> > From: SRAJENDRAN_at_nlfs.com [SMTP:SRAJENDRAN_at_nlfs.com]
> > Sent: Wed, January 16, 2002 10:05 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject: Database Views
> >
> > I would like get your opinion on what would be the best way provide
> access
> > to data across multiple databases on just on Node (database).
> >
> > One way that I have tried is create a view on one database that
> reads
> > tables
> > across remaining four databases using Dblinks. Let us say there is
> a
> > table
> > called CUSTOMER that resides on five databases, in order to make it
> easier
> > to generate reports, a combined view can be created with dblinks on
> these
> > tables using UNION ALL on one database.
> >
> > Only concern I have is that when using Dblinks, Oracle might copy
> the
> > entire
> > remote table to the local database and then retrieve the data based
> on
> > where
> > clause. This might be a significant performance issue especially
> if the
> > tables are very BIG.
> >
> > If there are better ways to accomplish this or any ideas on this
> one will
> > be
> > greatly appreciated.
> >
> > Thank you,
> > Srini
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author:
> > INET: SRAJENDRAN_at_nlfs.com
> >
> > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > San Diego, California -- Public Internet access / Mailing
> Lists
> >
> --------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like
> subscribing).
> > -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
> > This e-mail was scanned by the eSafe Mail Gateway
> > -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?=
> INET: adary_at_mehish.co.il
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing
> Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Do You Yahoo!?
Send FREE video emails in Yahoo! Mail!
http://promo.yahoo.com/videomail/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rachel Carmichael
INET: wisernet100_at_yahoo.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Thu Jan 17 2002 - 08:52:28 CST
