Chuck wrote:
> 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?
yes.
--
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Mon Aug 20 2007 - 11:53:01 CDT
