RE: Refresh option for Materialized view , want to use it during refresh - for

Hi Arup, This is a very good method. I would like to use it to modify some of my data loading procedures. Here are my questions: 1. Do I need to create the table on the step 1 every time when I refresh the data If I refresh data once per day? 2. Is "ON PREBUILT TABLE" available on Oracle 8i?

Re: Refresh option for Materialized view , want to use it during refresh - for

did i read that correctly that create table as is superior to a materialized view for nightly loads? We drop all the tables in some of our schemas and rebuild them with create table as statements. I was going to try out materialized views to see if they were faster. guess they are not? - Origi

Re: Refresh option for Materialized view , want to use it during refresh - for

David, Answers to your questions: (1) Without knowing your exact needs, I wil offer a few different scenarios. I am assuming that you are doing a complete refresh every time. The following pertain to that. Say, your name of the MV is MV1. Here are the steps the first time. 1. Create table MV1 2

Re: Refresh option for Materialized view , want to use it during refresh - for

No, you didn't read it completely. Create table and create MV do the same thing - produce a copy of the data on a different location (or a different segment) that can be queried independently. However, I proposed a different way of doing the MV creating and refreshing, not using the dbms_mview.refr

Re: Refresh option for Materialized view , want to use it during refresh - for

no we dont need query rewrite. we load data every night across a database link. we drop and recreate all the tables from scratch. I thought about using materialized views. i thought they might load faster because of fast refresh. not sure if we can do that across a db link. - Original Message -

Re: Refresh option for Materialized view , want to use it during refresh - for

> i thought they might load faster because of fast refresh. If you can do fast refresh, then MVs may be better. However, here are a few considerations before you do so: 1. Fast refresh requires creation of mv logs on the master tables, which are populated by triggers. This will affect performance

Re: Refresh option for Materialized view , want to use it during refresh - for

EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Subject: Re: Refresh option for Materialized view , want to use it during refresh - for Date: Fri, 24 Oct 2003 18:04:33 -0800 David, Answers to your questions: (1) Without knowing

Re: Refresh option for Materialized view , want to use it during refresh - for

> >Reply-To: [EMAIL PROTECTED] > >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > >Subject: Re: Refresh option for Materialized view , want to use it during > >refresh - for > >Date: Fri, 24 Oct 2003 18:04:33 -0800 > > > >David,

Re: Refresh option for Materialized view , want to use it during refresh - for

Thanks, Arup. Your advice is always good. David From: "Arup Nanda" <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Subject: Re: Refresh option for Materialized view , want to use it during refresh - for Date:

RE: Refresh option for Materialized view , want to use it during refresh - for Arup

Hi Arup,   Really appreciate for taking out time for answering to my query.   Thanks a ton for your solution. It fits perfectly for my problem.   Thanks once again   With Warm Regards Siddharth Haldankar Zensar Technologies Ltd. Cisco Systems Inc. (Offshore Developme

Re: Re: Refresh option for Materialized view , want to use it during refresh - for

Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Subject: Re: Refresh option for Materialized view , want to use it during refresh - > for > > Arup, > > I really appreciate your answer in great details. I got "on prebuilt table" > work. Thanks a