Re: materialized view via link slow after upgrade from 8i to 9i

Phil:
Gave it a shot . . .
This is the error message I got:

select * FROM admarc.nad_at_amp2
*
ERROR at line 8:
ORA-12015: cannot create a fast refresh materialized view from a complex query

??

Thanks!
Barb

On 11/4/05, Phil Jones <phillipjones_at_gmail.com> wrote:
>
> On 04/11/05, Barbara Baker <barb.baker_at_gmail.com> wrote:
>
> > REFRESH FORCE ON DEMAND
>
> Try REFRESH FAST ON DEMAND instead...
>
> Cheers,
>
> Phil
>

--
http://www.freelists.org/webpage/oracle-l