Re: materialized view via link slow after upgrade from 8i to 9i
- From: Barbara Baker <barb.baker@xxxxxxxxx>
- To: Phil Jones <phillipjones@xxxxxxxxx>
- Date: Fri, 4 Nov 2005 09:24:34 -0700
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:
