-
Hi,
i have created a materialized view in the following manner...
create MATERIALIZED view details_mv
build immediate
as
select /*+RULE */x.teet_number, x.teet_on,
sum(decode(x.ed, 'REGULAR', x.hours, 0)) rghs,
sum(test1),
sum(test2)
from x
group by x.teet_number, x.teet_on
there are some more columns in the select statement,
i have not written any code to refresh the data in the materialize d view and my DBA has set th eproperty to refresh after every one hour in DBA studio....
and my problem is even thought he has set to refresh after every one hour it doesn't refresh after every one hour,
may i please know what could be the problem,
thanks,
Radhakrishnan.M
-
You should determinate REFRESH method and rules :
when start update Mview (for example BUILD IMMEDIATE),
update interval or rule (for example ON COMMIT)
and so on.
...
alter MATERIALIZED view details_mv
refresh ON COMMIT COMPLETE;
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|