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@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@xxxxxxxxx> wrote:
>
> On 04/11/05, Barbara Baker <barb.baker@xxxxxxxxx> wrote:
>
> > REFRESH FORCE ON DEMAND
>
> Try REFRESH FAST ON DEMAND instead...
>
> Cheers,
>
> Phil
>

Other related posts: