Re: Database Views

This is why data marts were created.

You would be much better off to create a reporting database based on the data you need to see.

You won't be happy doing this with views from several databases.

It won't perform well. As Rachel pointed out it will be inconsistent.

At the very least you could create snapshots of these tables so that all of the data would be locally available.

Just my $0.02.

Jared

On Wednesday 16 January 2002 12:04, SRAJENDRAN_at_nlfs.com wrote:
> 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: Jared Still
  INET: jkstill_at_cybcon.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).