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).
--
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:13:50 CDT
