Home » Other » Training & Certification » materialized view to refresh every saturday
materialized view to refresh every saturday [message #255738] Wed, 01 August 2007 11:10 Go to next message
DRDBA
Messages: 20
Registered: March 2007
Junior Member
We have a requirement to create a materialized view
by selecting all columns from a table, The challenge is that
it needs to be refreshed on every saturday
Re: materialized view to refresh every saturday [message #255740 is a reply to message #255738] Wed, 01 August 2007 11:19 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
This should keep you busy a while.
Please read & FOLLOW posting guidelines as stated in the STICKY posts at top of this forum.
Re: materialized view to refresh every saturday [message #255751 is a reply to message #255738] Wed, 01 August 2007 11:55 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
So read the doc.

[Edit: I assume it is homework and put it there.]

Regards
Michel

[Updated on: Wed, 01 August 2007 11:56]

Report message to a moderator

Re: materialized view to refresh every saturday [message #255753 is a reply to message #255740] Wed, 01 August 2007 11:58 Go to previous message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Periodic Refresh of Materialized Views: Example

http://download.oracle.com/docs/cd/B12037_01/server.101/b10759/statements_6002.htm
Previous Topic: queries
Next Topic: OCA?
Goto Forum:
  


Current Time: Thu Dec 08 02:15:45 CST 2016

Total time taken to generate the page: 0.18962 seconds