materiaized view not running
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: materiaized view not running

  1. #1
    Join Date
    Jun 2000
    Location
    dumfries,va,usa
    Posts
    227

    materiaized view not running

    Hi,

    I have 6 materialized views setup to run daily but only 2 are running. Within the database, there are about 11 other scheduled jobs (13 total) and the job_queue_process is set to 12. The problem I'm having is only 2 of my 6 materialized views are showing up in dba_jobs and hence, are running. When I query user_snapshots the NEXT column is blank for the 4 that are not in dba_jobs.

    Can someone explain to me what is happening with 1) the jobs not being run, and 2) the NEXT column being blank.

    Thanks
    Leonard
    leonard905
    leonard905@yahoo.com

  2. #2
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    Have you tried something like ...

    Code:
    Alter Materialized View
       MY_MV
    Refresh
       Next   Trunc(SysDate,'DD')+1;
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width