OraFAQ Forum: Performance Tuning » Materialized View, which should refresh every Tuesday and Friday at 5am. (merged 2)

Home » RDBMS Server » Performance Tuning » Materialized View, which should refresh every Tuesday and Friday at 5am. (merged 2) (Oracle 11.2.0.2.0)

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

Materialized View, which should refresh every Tuesday and Friday at 5am. (merged 2) [message #548131]

Tue, 20 March 2012 08:24

vishnu_ora
Messages: 12
Registered: April 2011

Junior Member

Guys,

Please help me with ...

I need to create a Materialized View, which should refresh every Tuesday and Friday at 5am.

CREATE MATERIALIZED VIEW DUAL_MV
TABLESPACE USERS_SMALL
REFRESH NEXT NEXT_DAY(TRUNC(SYSDATE), 'TUESDAY') + 05/24
AS SELECT * FROM DUAL;

I can do it for single day like above, but how to refresh on multiple days, using create materialized view syntax ........

Report message to a moderator

Re: Materialized View, which should refresh every Tuesday and Friday at 5am. (merged 2) [message #548139 is a reply to message #548131]

Tue, 20 March 2012 08:50

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

CREATE MATERIALIZED VIEW DUAL_MV
TABLESPACE USERS_SMALL
REFRESH NEXT NEXT_DAY(TRUNC(SYSDATE), 'TUESDAY') + 05/24
AS SELECT * FROM DUAL;

CREATE MATERIALIZED VIEW DUAL_MV
TABLESPACE USERS_SMALL
REFRESH NEXT NEXT_DAY(TRUNC(SYSDATE), 'FRIDAY') + 05/24
AS SELECT * FROM DUAL;

Report message to a moderator

Re: Materialized View, which should refresh every Tuesday and Friday at 5am. (merged 2) [message #548143 is a reply to message #548131]

Tue, 20 March 2012 08:56

Michel Cadot
Messages: 68455
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

You can use a CASE expression, if current is TUESDAY then use SYSDATE+1+5/24 otherwise use your current expression (CASE WHEN ELSE).

Regards
Michel

Report message to a moderator

Previous Topic:	How to find Local and global indexes on Particular Table
Next Topic:	New User Help Me Out (merged 2)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jun 07 17:41:35 CDT 2023