Home » Developer & Programmer » Data Integration » Materialized view
Materialized view [message #93386] Mon, 18 October 2004 02:59
Mahadeo
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

Regs
Mahadeo

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


Current Time: Thu Mar 28 14:31:23 CDT 2024