Database Administration (MOSC)

MOSC Banner

Set up dbms_refresh.make interval for every 15 minutes monday-friday 5am-6pm

edited Sep 24, 2020 10:31PM in Database Administration (MOSC) 9 commentsAnswered ✓

Hi, I would like to set up my materialized group refresh to run every 15 minutes monday - friday, 5am to 6pm.  How do I set the interval for those parameters?  Currently it just runs every 15 minutes every day.  Here's what I currently have:

BEGIN

DBMS_REFRESH.MAKE(

name => '"MIKE"."MY_REFRESH"',

list => '',

next_date => SYSDATE,

interval => '/*15:Mins*/ sysdate + 15/(60*24)',

implicit_destroy => FALSE,

lax => FALSE,

job => 0,

rollback_seg => NULL,

push_deferred_rpc => FALSE,

refresh_after_errors => FALSE,

purge_option => 1,

parallelism => 4,

heap_size => NULL);

END;

/

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center