Swaminathan K
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 ?
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.