Home » SQL & PL/SQL » SQL & PL/SQL » how to check when a materialized view was refreshed last
how to check when a materialized view was refreshed last [message #213544] Thu, 11 January 2007 03:51 Go to next message
camry
Messages: 5
Registered: January 2007
Junior Member
Hi, I have a materialzed view that is set to refresh everyday. but I see a discrepancy in it's data and the source data. How can I check if the last refresh was successful and when was it.
For creation I had used following:

CREATE materialized VIEW xxxx_bil_org_aged
REFRESH START WITH ROUND(SYSDATE+1)+6/24
WITH PRIMARY KEY
AS SELECT * FROM bil_orgs@D1

Thanks !!
Re: how to check when a materialized view was refreshed last [message #213560 is a reply to message #213544] Thu, 11 January 2007 04:58 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Check LAST_REFRESH in DBA_MVIEW_REFRESH_TIMES.

[Updated on: Thu, 11 January 2007 04:58]

Report message to a moderator

Re: how to check when a materialized view was refreshed last [message #213574 is a reply to message #213560] Thu, 11 January 2007 05:41 Go to previous message
camry
Messages: 5
Registered: January 2007
Junior Member
Thanks much !!
Previous Topic: Performance Issue
Next Topic: how to call Unix executable from sql plus
Goto Forum:
  


Current Time: Mon Dec 05 08:31:50 CST 2016

Total time taken to generate the page: 0.05813 seconds