If you use refresh group you have to remove the refresh interval from MV creation script. On 6/14/05, Steiner, Randy <RASTEIN@xxxxxxxx> wrote: > Thanks!!!!!! >=20 >=20 > > -----Original Message----- > > From: David Sharples [mailto:davidsharples@xxxxxxxxx] > > Sent: Tuesday, June 14, 2005 9:47 AM > > To: Steiner, Randy > > Cc: oracle-l@xxxxxxxxxxxxx > > Subject: Re: ddl extract for materialized view > >=3D20 > > dbms_metadata > >=3D20 > > On 6/14/05, Steiner, Randy <RASTEIN@xxxxxxxx> wrote: > > Does anyone know how to extract the ddl? > -- > //www.freelists.org/webpage/oracle-l > -- //www.freelists.org/webpage/oracle-l