Home » SQL & PL/SQL » SQL & PL/SQL » Materialized view refresh (merged 2 threads)
Materialized view refresh (merged 2 threads) [message #207996] Thu, 07 December 2006 14:08 Go to next message
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
rleishman
Messages: 3724
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
Re: Materialized View refreshed with invoker's schema [message #208026 is a reply to message #207997] Thu, 07 December 2006 20:20 Go to previous message
rleishman
Messages: 3724
Registered: October 2005
Location: Melbourne, Australia
Senior Member
Don't attach additional questions to someone elses post. You have posted this question in this forum once already - wait for a reply on that.
Previous Topic: ordering by a non-database item
Next Topic: Unable to create materialized view over db link
Goto Forum:
  


Current Time: Mon Dec 05 04:38:57 CST 2016

Total time taken to generate the page: 0.13540 seconds