stored procedure to update materialized view 1

[mikedaruke]

Can someone write me a stored procedure that updates a materialized view? Reason is I am trying to use perl to update the view, via cron, and it gives me errors, so I am thinking maybe just running a stored procedure to update it.

Any ideas?

 

[SantaMufasa]

Can someone write me a stored procedure that updates a materialized view?

Yes, I'm sure someone can <grin>.


But how about you take a stab at it first and then post the code here. We'll be happy to help on that basis.

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

 

[Dagon]

Some kindly person in Oracle already did this for you. Try dbms_mview.refresh.

 

[SantaMufasa]

I liiiiiiiike it! Hava

, Dagon, for not only helping out Mike, but showing me something that I didn't know was there.

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