Unless of course you created them with manual refresh only in the first place. Jared On 6/15/05, Sami Seerangan <dba.orcl@xxxxxxxxx> wrote: > > If you use refresh group you have to remove the refresh interval from > MV creation script. > > -- Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist