| Materialized View.. [message #43557] |
Sun, 03 August 2003 23:56  |
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  |
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
