Home » Developer & Programmer » Data Integration » Materialized view
Materialized view [message #93386] Mon, 18 October 2004 02:59
Messages: 1
Registered: October 2004
Junior Member

This is regarding the materialized view i have created on the tabel with the joins and subquery and i have set the time to get it refreshed every day at 6.00 a.m.

But the problem is that whenever i see the refresh time of that particular Materialized view it gets postponed by 30 to 40 secs i.e the time taken by the materialized view to refresh. So after on or two months it will get refreshed at 7.00 a.m instead of 6.00a.m

Can you please let me know that what can be done so that it refreshes at dot 6.00 am everyday with the fast refresh option of materialized view


Previous Topic: Question
Next Topic: Connecting to SQL server DB in OWB
Goto Forum:

Current Time: Sun Nov 28 03:12:19 CST 2021