oracle 物化视图子查询问题 ora-22818

Question

create materialized view test as
select d.name,
(select count(1) from tab1 t1 where t1.card=t2.card) con
from tab2 t2
报错 ora-22818 怎么破~

Answer 1

1、先封建到一个普通视图
create view v_test as
select d.name,
(select count(1) from tab1 t1 where t1.card=t2.card) con
from tab2 t2

2、创建物化视图
create materialized view mv_test as
select * from v_test

Answer 2

物化视图 select d.name,后面不能是子查询 ，这种写法是不支持的

Answer 3

where 条件写的有问题，改一下吧

追问

啊？ 清楚点

追答

where t1.card=t2.card) 这句写的有问题