Home » SQL & PL/SQL » SQL & PL/SQL » Materialized view refresh (Oracle 9i)
icon5.gif  Materialized view refresh [message #312297] Tue, 08 April 2008 08:12 Go to next message
Messages: 8
Registered: April 2007
Junior Member
Hi everybody.
I´m from Brazil, so I´d like to say sorry for my english.
I have created a materialized view but it´s not good because the refresh option is wrong.
Actually I need to refresh the materialized view only at 3rd and 18th days of the month and I dont know how I could do this.
Any help will be great.

My email is riassuncao@bol.com.br

Re: Materialized view refresh [message #312303 is a reply to message #312297] Tue, 08 April 2008 08:37 Go to previous message
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Set your MV to REFRESH ON DEMAND, and then create a job using DBMS_JOB, DBMS_SCHEDULER, or an O/S task scheduler like Cron that will call the <url=http://download.oracle.com/docs/cd/B10501_01/appdev.920/a96612/d_mview.htm#93762>DBMS_MVIEW</url> package to refresh the view on the days that the job runs.
Previous Topic: In need of code ideas (merged)
Next Topic: Convert Short Date to Date
Goto Forum:

Current Time: Mon Oct 24 21:10:24 CDT 2016

Total time taken to generate the page: 0.17287 seconds