Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Is it possible to refresh a Materialized view on demand ?
Hi all!
I've created a Materialized view with this options:
CREATE MATERIALIZED VIEW MVW_LINKS
REFRESH FORCE ON DEMAND
WITH ROWID
START WITH TO_DATE('10-03-2005 23.00.29', 'DD-MM-YYYY HH24:MI:SS') NEXT
SYSDATE + 1
AS
SELECT * .......
I'd like to know how to reload the Mat.view on demand (ie. without
waiting for sysdate +1).
Anybody knows ?
Thanks
Francesco
Received on Thu Mar 10 2005 - 02:45:22 CST