Materilized view JOB

[kiranrajenimbalkar]

Hi,

Please provide me the SQL for creating Materilized view JOB in Oracle or Changing the timing to sysdate + 1 from exesting JOB.


Regards,
Kiran

[debasisdas]

what do you mean by Materilized view JOB ?

are you trying to refresh a/some materialized view using job ?

[kiranrajenimbalkar]

Hi,

Yes i am trying to refresh time i.e i have to change the JOB time from sysdate +1/2 to sysdate+1.so please provide me the SQL script for the same.

Regards,
Kiran

[debasisdas]

Please find the details here, here and here .