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

Frank van Bortel wrote:
> 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

Ok, clear
regards
Francesco Received on Fri Mar 11 2005 - 03:07:43 CST