| Materialized view refresh (merged 2 threads) [message #207996] |
Thu, 07 December 2006 14:08  |
deepakv
Messages: 3
Registered: September 2006
|
Junior Member |
|
|
Hi,
I have a materilized view and it will be fast refreshed every day. During that process if a query is using that materialized view, will it fail?
if yes how can I resolve that
Appreciate your help
Deepak
|
|
|
|
| materialized view refresh [message #207997 is a reply to message #207996] |
Thu, 07 December 2006 14:11  |
deepakv
Messages: 3
Registered: September 2006
|
Junior Member |
|
|
Hi,
I have a materilized view and it will be fast refreshed every day. During that process if a query is using that materialized view, will it fail?
if yes how can I resolve that
Appreciate your help
Deepak
|
|
|
|
| Re: Materialized view refresh [message #208025 is a reply to message #207996] |
Thu, 07 December 2006 20:19 |
rleishman
Messages: 3728
Registered: October 2005
Location: Melbourne, Australia
|
Senior Member |
|
|
It will probably be OK providing you do not COMPLETE refresh, and also providing you do not PCT refresh (if none of the tables involved are partitioned, you do not have to worry about this). If either of these things happen, then some or all of the table will be truncated.
There's always a risk when you refresh an active MV because you could get ORA-01555 (Snapshot Too Old) errors on long-running user-queries.
Ross Leishman
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
