Re: Materialized Views

From: Anurag Varma <avarmadba.skipthis_at_yahoo.com>
Date: Wed, 02 Jul 2003 18:08:29 GMT
Message-ID: <xcFMa.12321$JY1.1702@nwrddc01.gnilink.net>

"203.99.143.60" <Rath.Yelandur_at_Spam.Nope> wrote in message news:3f030e84_at_shknews01...
> Hey guys,
>
> We want to MATERIALIZED VIEWS for some of the reports involving large
> volumes of data. These involve multiple tables/view joins.
>
> Are there any limitations on using Materialized views. We are currently
> running ORACLE 8.1.7 Server.
>
> What are the do's & dont's w.r.t. Materialized views.
>
> Thanks in advance,
> Rath
>
>

Look in the Data Warehouse manual and the sql reference manual. The do's and don'ts are listed in there afaik.
http://tahiti.oracle.com

Anurag Received on Wed Jul 02 2003 - 13:08:29 CDT