Database Administration (MOSC)

MOSC Banner

Materialized view is there a way to remove the scheduled job via the alter command

edited Jul 25, 2019 5:03AM in Database Administration (MOSC) 3 commentsAnswered

Good morning.  This is for Oracle 12.1 or 12.2.

The developers have created a materialized view and scheduled a job to refresh daily using this:

     START WITH TO_DATE('16-05-2019 05:00:00','dd-mm-yyyy hh24:mi:ss')   NEXT trunc(sysdate) + 05/24 + 1 /* 5:00 a.m. *

i have tried figuring this out but have not found anything.

Is there an alter materialized view command to remove this schedule?

(instead of dropping and recreating the view)

Thanks for the help.

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