Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> dba_jobs v. dba_scheduler_jobs
I just recently transitioned from 9i to 10g. One question not covered in
the new features class was dba_jobs v. dba_scheduler_jobs. I'm asking
because I thought that the 10g scheduler replaced the old dbms_jobs
package, but when I created a materialized view on 10g and set up
automatic refreshing (through a refresh group), the refresh job used
the old dbms_jobs package. Is there a way to make it use the scheduler
instead? Is there any advantage to using the scheduler for refreshing
mviews? TIA.
Received on Mon Aug 20 2007 - 09:03:07 CDT
![]() |
![]() |