SQL> create materialized view log on zdnzf_info_zkr@shuangqiao with primary key
2 /
create materialized view log on zdnzf_info_zkr@shuangqiao with primary key
ORA-00949: illegal reference to remote database谢谢!
2 /
create materialized view log on zdnzf_info_zkr@shuangqiao with primary key
ORA-00949: illegal reference to remote database谢谢!
有结果么?
提示你是远程数据库的表访问不到,
即使在当前数据库上,给远程数据库的表建立了SYNONYM,也不行。
create materialized view mv_table
refresh with primary key
as select * from zdnzf_info_zkr@shuangqiao;