var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: sequencial jobs
I've got a large number of materialized views, and they must be refreshed in a order, and the next one should only start when the last one completes sucessfully.
What I'm doing now it's putting each refresh on a job, starting each one with several hours apart. But this is not accurate, because I realy never know how much time a refresh take.
Could someone point me a better solution?
If they need to be refreshed in exact order, why don't you put all of them into a single script and run it (either at once, or schedule through a DBMS_JOB or DBMS_SCHEDULER)? Something like
Run it as
CREATE OR REPLACE PROCEDURE prc_refresh_mv IS
or schedule as
what => 'prc_refresh_mv;',
next_date => TRUNC(SYSDATE) + 16/24,
interval => 'SYSDATE + 1'
the simple things always passes me by.......