Link to home
Start Free TrialLog in
Avatar of Swaminathan K
Swaminathan KFlag for India

asked on

Materialized view refresh

Hi Team,

I need an help in creating an materialzed view which will do a incremental refresh in the week days and full refresh in the weekends

The challenge is I want to how to refresh for the view as the view is created by select * from view name i.e it gets data from the view and base tables.
The below is the implementation
Create or replace viewname
as Select a.col1 ,b. Col2
from tab1 a , tab2 b
where a.col3=b.col4

Create or replace viewname1
as Select a.col3 ,b. Col5,b.col6
from tab1 a , tab2 b
where a.col1=b.col2

Create or replace viewname2
as Select a.col1 ,b. Col5,b.col6
from viewname a , viewname1 b
where a.col1=b.col2


Now the materialized view is created as below

CREATE MATERIALIZED VIEW matrialized1
     PARALLEL 4
     BUILD IMMEDIATE
     REFRESH COMPLETE
Select * from viewname2;

I want to refresh the view in incremental during weekdays and full refresh on the weekends. Also when Iam trying to refresh the view , should I create the materialized log on the base tables or the views ?
ASKER CERTIFIED SOLUTION
Avatar of johnsone
johnsone
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial