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
binho_sjc
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.
Thanks.

My email is riassuncao@bol.com.br

bye
Re: Materialized view refresh [message #312303 is a reply to message #312297] Tue, 08 April 2008 08:37 Go to previous message
JRowbottom
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: Sun Dec 04 19:02:04 CST 2016

Total time taken to generate the page: 0.13024 seconds