| 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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
