DA Morgan wrote:
> Chuck wrote:
>> 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.
>
> DBMS_SCHEDULER is more capable and more flexible than DBMS_JOBS so if
> you are writing new functionality it is a better tool. Oracle, on the
> other hand, still hasn't figured out how to get the LONG data type
> out of the data dictionary (248 uses in 11gR1).
So then it is still SOP to use dbms_jobs for refreshing mviews?
Received on Mon Aug 20 2007 - 11:41:50 CDT
