Home » SQL & PL/SQL » SQL & PL/SQL » Need Materialised view
Need Materialised view [message #624633] Wed, 24 September 2014 06:32 Go to next message
mvrkr44
Messages: 132
Registered: December 2012
Senior Member
I need to create a materialaised view to execute 3.00 AM & 4 AM & 3 PM every day...how can i achieve it

Report message to a moderator

Re: Need Materialised view [message #624634 is a reply to message #624633] Wed, 24 September 2014 06:41 Go to previous messageGo to next message
ind!@2020
Messages: 23
Registered: September 2014
Location: India
Junior Member

1.First create a MV.
2.Schedule it to run at 3am,4am and 3pm

Report message to a moderator

Re: Need Materialised view [message #624636 is a reply to message #624633] Wed, 24 September 2014 06:54 Go to previous message
Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web
Senior Member
mvrkr44 wrote on Wed, 24 September 2014 17:02
I need to create a materialaised view to execute 3.00 AM & 4 AM & 3 PM every day


For easy maintenance, schedule DBMS_MVIEW.REFRESH for your MV using DBMS_SCHEDULER. Yes, you could specify it while creating the MV itself, however, it does the same thing, implicitly creates a job and calls DBMS_MVIEW.REFRESH based on start with and next.

Report message to a moderator

Previous Topic: minus operator question
Next Topic: DECODE not working the way expected
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Apr 23 23:59:33 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.