Re: Is it possible to refresh a Materialized view on demand ?

From: Frank van Bortel <fvanbortel_at_netscape.net>
Date: Thu, 10 Mar 2005 14:29:29 +0100
Message-ID: <d0phv0$74k$1@news1.zwoll1.ov.home.nl>

fmarchioni_at_libero.it wrote:
> 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
>

Your refresh time is off; your format mask uses ':', you use '.'

manually refreshing: look into dbms_refresh (obvious, not?) Search docs.oracle.com for all documentation in current versions (8i, 9i and 10g)

-- 
Regards,
Frank van Bortel

Received on Thu Mar 10 2005 - 07:29:29 CST