我现在建立物化视图是可以的,但都是基于同库同用户名下。物化同库不同用户名下的表或视图是怎么操作的,还是就是不同库是怎么物化的?我在同库的a用户名下可以查询出b用户名下的视图或表,select * from b.*。这是能查询出来的,但是在a下建立b中的某个表或视图的物化视图却提示找不到表或视图,希望大家帮我解决,谢谢了。
CREATE MATERIALIZED VIEW LOG ON kfsj.pc_pk_cy4_org WITH ROWID CREATE MATERIALIZED VIEW MV_kfsj.pc_pk_cy4_org build immediate refresh on commit WITH ROWID AS SELECT t.rowid trowid,t.* from kfsj.pc_pk_cy4_org --------------------------------------------------- 这是我建立物化视图的语句,麻烦你了,帮我看看
CREATE MATERIALIZED VIEW LOG ON kfsj.pc_pk_cy4_org WITH ROWID CREATE MATERIALIZED VIEW MV_kfsj.pc_pk_cy4_org build immediate refresh on commit WITH ROWID AS SELECT t.rowid trowid,t.* from kfsj.pc_pk_cy4_org --------------------------------------------------- 这是我建立物化视图的语句,麻烦你了,帮我看看
grant create table to a;
grant select on b.table to a;权限问题:
http://blog.itpub.net/post/468/50672
CREATE MATERIALIZED VIEW LOG ON kfsj.pc_pk_cy4_org
WITH ROWID
CREATE MATERIALIZED VIEW MV_kfsj.pc_pk_cy4_org
build immediate
refresh on commit
WITH ROWID
AS
SELECT t.rowid trowid,t.* from kfsj.pc_pk_cy4_org
---------------------------------------------------
这是我建立物化视图的语句,麻烦你了,帮我看看
WITH ROWID
CREATE MATERIALIZED VIEW MV_kfsj.pc_pk_cy4_org
build immediate
refresh on commit
WITH ROWID
AS
SELECT t.rowid trowid,t.* from kfsj.pc_pk_cy4_org
---------------------------------------------------
这是我建立物化视图的语句,麻烦你了,帮我看看
物化视图日志是建立在B方