Very new to this topic – using 11g.
When I create a materialized view, a matching job (not a scheduler job) is created. But it's my understanding that dbms_job
is being replaced by dbms_scheduler
.
Am I doing something wrong or am I totally misunderstanding what's going on?
Best Answer
You are not doing anything wrong and your understanding is correct. Materialized views that are created or altered to have a refresh schedule use
DBMS_JOB
rather thanDBMS_SCHEDULER
. This would be unexpected given the following wording from the 11.2 Administrators Guide (emphasis mine):I agree with Jack Douglas and the comments he linked to.
DBMS_JOB
is unlikely to go away anytime soon.