Materialized View Update

[THoey]

Hi all,

Just need to check to see if I did something right. I have created a Materialized View on a local instance of a table from a distant database instance. I want this MView to refresh every hour. I created the view and the log file with the following code:

-- CREATE MATERIALIZED VIEW LOG ON TABLE ON MASTER DATABASE:

CREATE MATERIALIZED VIEW LOG ON CFG_GROUP 
PCTFREE 5 TABLESPACE CME2TS01 
STORAGE (INITIAL 10K NEXT 10K); 

-- CREATE MATERIALIZED VIEW ON TABLE ON SLAVE DATABASE:

CREATE MATERIALIZED VIEW MV_CFG_GROUP
PCTFREE 5 PCTUSED 60 
TABLESPACE DM_DAT 
STORAGE (INITIAL 50K NEXT 50K) 
USING INDEX STORAGE (INITIAL 25K NEXT 25K)
REFRESH FAST 
START WITH ROUND(SYSDATE) + 06/24 
NEXT SYSDATE + 01/24 
AS SELECT * FROM CFG_GROUP@CCT1;

I can see the view as a local table and it is filled with data. The question I have is whether the view is setup right to refresh every hour. I do not own the distant end source table, so I cannot change it to test it.

Does this look right?

Thanks in advance.

Terry
**************************
* General Disclaimer - Please read *
**************************
Please make sure your post is in the CORRECT forum, has a descriptive title, gives as much detail to the problem as possible, and has examples of expected results. This will enable me and others to help you faster...