CREATE MATERIALIZED VIEW v1 ENABLE QUERY REWRITE BUILD IMMEDIATE REFRESH COMPLETE AS Select dwdm,Sum(Rcy),Sum(Rcy1),Sum(Rcs) from table1,table2 where table1.id=table2.id group by dwdm
CREATE MATERIALIZED VIEW v1 ENABLE QUERY REWRITE BUILD IMMEDIATE REFRESH COMPLETE AS Select dwdm,Sum(Rcy),Sum(Rcy1),Sum(Rcs) from table1,table2 where table1.id=table2.id group by dwdm
CREATE MATERIALIZED VIEW v1 ENABLE QUERY REWRITE BUILD IMMEDIATE REFRESH COMPLETE AS Select dwdm,Sum(Rcy),Sum(Rcy1),Sum(Rcs) from table1@DBlink A,table2@DBlink B where A.id=B.id group by dwdm可以这么做么?
我建立视图,还是有问题: CREATE MATERIALIZED VIEW v_s_dba01 REFRESH FAST ON COMMIT BUILD IMMEDIATE AS select a.dwdm,a.qkdydm,a.rq,a.cyfs,count(a.jh),SUM(a.SCSJ), SUM(a.RCYL1),SUM(a.RCYL),SUM(a.RCSL),SUM(a.RCQL) from gd.DAA01@cjdw1 a,gd.DBA01@cjdw1 b where a.jh=b.jh group by a.dwdm,a.qkdydm,a.rq,a.cyfsORA-00905: 缺少关键字
gd.DAA01(前边是用户名)下边是DAA01的字段 dwdm, qkdydm, cyfsgd.DBA01(前边是用户名)下边是DBA01的字段 JH, RQ, SCSJ, RCYL1, RCYL, RCSL, RCQL上边的结构,建立物化试图是: CREATE MATERIALIZED VIEW v_s_dba01 REFRESH FAST ON COMMIT BUILD IMMEDIATE AS select a.dwdm,a.qkdydm,b.rq,a.cyfs,count(b.jh),SUM(b.SCSJ), SUM(b.RCYL1),SUM(b.RCYL),SUM(b.RCSL),SUM(b.RCQL) from gd.DAA01@cjdw1 a,gd.DBA01@cjdw1 b where a.jh=b.jh group by a.dwdm,a.qkdydm,b.rq,a.cyfsORA-00905: 缺少关键字请相救!
gd.DAA01(前边是用户名)下边是DAA01的字段 JH, dwdm, qkdydm, cyfsgd.DBA01(前边是用户名)下边是DBA01的字段 JH, RQ, SCSJ, RCYL1, RCYL, RCSL, RCQL上边的结构,建立物化试图是: CREATE MATERIALIZED VIEW v_s_dba01 REFRESH FAST ON COMMIT BUILD IMMEDIATE AS select a.dwdm,a.qkdydm,b.rq,a.cyfs,count(b.jh),SUM(b.SCSJ), SUM(b.RCYL1),SUM(b.RCYL),SUM(b.RCSL),SUM(b.RCQL) from gd.DAA01@cjdw1 a,gd.DBA01@cjdw1 b where a.jh=b.jh group by a.dwdm,a.qkdydm,b.rq,a.cyfsORA-00905: 缺少关键字请相救!
ENABLE QUERY REWRITE
BUILD IMMEDIATE
REFRESH COMPLETE
AS
Select dwdm,Sum(Rcy),Sum(Rcy1),Sum(Rcs) from table1,table2
where table1.id=table2.id
group by dwdm
ENABLE QUERY REWRITE
BUILD IMMEDIATE
REFRESH COMPLETE
AS
Select dwdm,Sum(Rcy),Sum(Rcy1),Sum(Rcs) from table1,table2
where table1.id=table2.id
group by dwdm
ENABLE QUERY REWRITE
BUILD IMMEDIATE
REFRESH COMPLETE
AS
Select dwdm,Sum(Rcy),Sum(Rcy1),Sum(Rcs) from table1@DBlink A,table2@DBlink B
where A.id=B.id
group by dwdm可以这么做么?
CREATE MATERIALIZED VIEW v_s_dba01 REFRESH FAST ON COMMIT
BUILD IMMEDIATE
AS select a.dwdm,a.qkdydm,a.rq,a.cyfs,count(a.jh),SUM(a.SCSJ),
SUM(a.RCYL1),SUM(a.RCYL),SUM(a.RCSL),SUM(a.RCQL)
from gd.DAA01@cjdw1 a,gd.DBA01@cjdw1 b
where a.jh=b.jh
group by a.dwdm,a.qkdydm,a.rq,a.cyfsORA-00905: 缺少关键字
dwdm,
qkdydm,
cyfsgd.DBA01(前边是用户名)下边是DBA01的字段
JH,
RQ,
SCSJ,
RCYL1,
RCYL,
RCSL,
RCQL上边的结构,建立物化试图是:
CREATE MATERIALIZED VIEW v_s_dba01 REFRESH FAST ON COMMIT
BUILD IMMEDIATE
AS select a.dwdm,a.qkdydm,b.rq,a.cyfs,count(b.jh),SUM(b.SCSJ),
SUM(b.RCYL1),SUM(b.RCYL),SUM(b.RCSL),SUM(b.RCQL)
from gd.DAA01@cjdw1 a,gd.DBA01@cjdw1 b
where a.jh=b.jh
group by a.dwdm,a.qkdydm,b.rq,a.cyfsORA-00905: 缺少关键字请相救!
JH,
dwdm,
qkdydm,
cyfsgd.DBA01(前边是用户名)下边是DBA01的字段
JH,
RQ,
SCSJ,
RCYL1,
RCYL,
RCSL,
RCQL上边的结构,建立物化试图是:
CREATE MATERIALIZED VIEW v_s_dba01 REFRESH FAST ON COMMIT
BUILD IMMEDIATE
AS select a.dwdm,a.qkdydm,b.rq,a.cyfs,count(b.jh),SUM(b.SCSJ),
SUM(b.RCYL1),SUM(b.RCYL),SUM(b.RCSL),SUM(b.RCQL)
from gd.DAA01@cjdw1 a,gd.DBA01@cjdw1 b
where a.jh=b.jh
group by a.dwdm,a.qkdydm,b.rq,a.cyfsORA-00905: 缺少关键字请相救!