Tag Info

New answers tagged


I'm successfully able to create a scheduler for my MV to refresh every minutes if the status stallness is not FRESH. Here's my solutions : I created a schedules to be used in my scheduler: BEGIN sys.dbms_scheduler.create_schedule( repeat_interval => 'FREQ=MINUTELY', start_date => to_timestamp_tz('2015-06-09 01:41:55 Asia/Jakarta', ...

Top 50 recent answers are included