MATERIALIZED VIEW [message #63617] |
Thu, 21 October 2004 01:47 |
Maarten
Messages: 9 Registered: October 2004
|
Junior Member |
|
|
Hi!
I have created a materialized view as:
CREATE MATERIALIZED VIEW MV_REEL_PART
REFRESH START WITH TRUNC(SYSDATE)+15/24
NEXT TRUNC(SYSDATE+1) + 8/24
AS SELECT REEL_ID, PROD_CODE, SUPPLIER_ID
, MAKING_NBR, STATUS_CODE
FROM REEL@WHS1DATA;
I have to be sure that the refresh takes place every day at 08:00, so I want to verify that. But where can I find the refresh information? In DBA_MVIEW_REFRESH_TIMES you can only see the LAST_REFRESH, not when the next is going to take place. So, does anyone knows where to find the interval info?
Thanks!
|
|
|
|
Re: MATERIALIZED VIEW [message #63633 is a reply to message #63625] |
Thu, 21 October 2004 10:26 |
andrew again
Messages: 2577 Registered: March 2000
|
Senior Member |
|
|
Just look in user_jobs. The MV create a dbms_job entry. You can modify the dbms_job interval expression (but the MV interval definition won't change so be careful when you export/import).
|
|
|