Materialized view

[mikedaruke]

How do I refresh a Materialized View?

I have it set to force and it refreshes every day. But I just happend to need up to date information right now, how do I just have it run again?

 

[SantaMufasa]

Mike,

SQL> execute DBMS_SNAPSHOT.REFRESH( '<MV Name>','<refresh type code>');

<refresh type code> can be either:

'f' = Fast refresh
'c' = Complete refresh

Let us know if this does what you want.



Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]