Home » SQL & PL/SQL » SQL & PL/SQL » refresh a materialized view
refresh a materialized view [message #396976] Wed, 08 April 2009 09:31 Go to next message
Alex4u
Messages: 3
Registered: January 2009
Junior Member

hi all,

i have created a simple materialized view using the following code:

create materialized view mv1
refresh fast
start with sysdate + 10/14440
next sysdate +1
as
select * from table1;

[i have created a materialized view log as well]

but the problem is that the materialized view mv1 doesnt get refreshed at the specified time.

it works well when i refresh it manually with (dbms_mview.refresh.....) but not at the time interval i had specified.

can anyone help me with this ?


thank you,
Re: refresh a materialized view [message #396980 is a reply to message #396976] Wed, 08 April 2009 09:34 Go to previous messageGo to next message
user2004
Messages: 33
Registered: April 2009
Member
Use TRUNC(sysdate)
Otherwise it would be lag behind while refreshing.
Why you want to create materialized view on the entire table?

[Updated on: Wed, 08 April 2009 09:38]

Report message to a moderator

Re: refresh a materialized view [message #396988 is a reply to message #396976] Wed, 08 April 2009 10:11 Go to previous messageGo to next message
Michel Cadot
Messages: 64130
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
but the problem is that the materialized view mv1 doesnt get refreshed at the specified time.

Do you mean it does not refresh at all or it refreshes at a time you think it should?
What is your refreshment requirement?

Regards
Michel
Re: refresh a materialized view [message #396997 is a reply to message #396976] Wed, 08 April 2009 10:23 Go to previous message
user2004
Messages: 33
Registered: April 2009
Member
	SELECT TO_CHAR(LAST_REFRESH, 'Mon DD, YYYY HH24:MM:SS') FROM  USER_MVIEW_REFRESH_TIMES WHERE NAME='MV1';


You can check...
Previous Topic: insufficient privilages in create view
Next Topic: please correct this trigger
Goto Forum:
  


Current Time: Wed Dec 07 10:21:49 CST 2016

Total time taken to generate the page: 0.13673 seconds