Home » Server Options » Replication » Materialized View..
Materialized View.. [message #43557] Sun, 03 August 2003 23:56 Go to next message
Suraj Kothari
Messages: 7
Registered: August 2003
Junior Member
Hi
I need help from you. I have created a materialized view s_snap. the syntax is given below. The data only gets updated manually but is not refreshing automatically even after stating the next refresh construct.

CREATE MATERIALIZED VIEW S_SNAP
STORAGE (INITIAL 100K NEXT 100K PCTINCREASE 0)
TABLESPACE VSNL
REFRESH COMPLETE
START WITH sysdate NEXT sysdate + 1
WITH ROWID
AS
SELECT * from s@itu;

also can i refresh the snap in minutes...
Please help.
Thanks and regards,
Suraj
Re: Materialized View.. [message #43581 is a reply to message #43557] Tue, 05 August 2003 07:18 Go to previous message
William Robertson
Messages: 1643
Registered: August 2003
Location: London, UK
Senior Member
Materialized view refresh uses the DBMS_JOB scheduler. Maybe you don't have any job queue processes running on your database.

btw,
> STORAGE (INITIAL 100K NEXT 100K PCTINCREASE 0)
If you are on 8i you should be using locally managed tablespaces wherever possible.
Previous Topic: Snapshots/Materialized Views - M$Log Tables
Next Topic: Replication Set up
Goto Forum:
  


Current Time: Thu Sep 23 06:34:14 CDT 2021