Home » Server Options » Replication » MATERIALIZED VIEW
MATERIALIZED VIEW [message #63617] Thu, 21 October 2004 01:47 Go to next message
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 #63625 is a reply to message #63617] Thu, 21 October 2004 06:14 Go to previous messageGo to next message
Maarten
Messages: 9
Registered: October 2004
Junior Member
In DBA_REFRESH_CHILDREN.
Re: MATERIALIZED VIEW [message #63633 is a reply to message #63625] Thu, 21 October 2004 10:26 Go to previous message
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).
Previous Topic: 3 Master sites - Group Problem ?!
Next Topic: Apps running on a snapshot replication environment
Goto Forum:
  


Current Time: Thu Mar 28 07:23:41 CDT 2024