OraFAQ Forum: Training & Certification » materialized view to refresh every saturday

Home » Other » Training & Certification » materialized view to refresh every saturday

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

materialized view to refresh every saturday [message #255738]

Wed, 01 August 2007 11:10

DRDBA
Messages: 22
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

Report message to a moderator

Re: materialized view to refresh every saturday [message #255740 is a reply to message #255738]

Wed, 01 August 2007 11:19

BlackSwan
Messages: 26766
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.

Report message to a moderator

Re: materialized view to refresh every saturday [message #255751 is a reply to message #255738]

Wed, 01 August 2007 11:55

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

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

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

Report message to a moderator

Previous Topic:	queries
Next Topic:	OCA?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Nov 27 23:58:24 CST 2024