Re: Refresh materialized view

From: DA Morgan <damorgan_at_psoug.org>
Date: Sun, 12 Jun 2005 10:19:12 -0700
Message-ID: <1118596768.534545@yasure>

Frank van Bortel wrote:
> William Robertson wrote:
>

>>Or for a single MV (or comma-separated list or DBMS_UTILITY.UNCL_ARRAY
>>collection), DBMS_MVIEW.REFRESH('mview list')
>>

>
> I was wondering about dbms_mview, and could not find it; assumed
> it obsolete in 10g, without realizing it's a synonym for dbms_snapshot.

And the DBMS_MVIEW synonym is in 10gR1.

SQL> select object_name from dba_objects

   2 where object_name = 'DBMS_MVIEW';

OBJECT_NAME

---

DBMS_MVIEW SQL>

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)

Received on Sun Jun 12 2005 - 12:19:12 CDT