Get ORA-942 When Creating Mview Over Dblink When Double Quotes Used In Connect To Clause
(Doc ID 602390.1)
Last updated on AUGUST 04, 2018
Applies to:Oracle Server - Enterprise Edition - Version: 10.2.0.3
Information in this document applies to any platform.
Creating an mview over a dblink fails with ORA-942.
create database link to_11g connect to "scott" identified by "tiger" using 'to_11g';
select count (*) from emp@to_11g; -- works
create materialized view mv_emp as select * from emp@to_11g ; -- fails
create materialized view mv_emp as select * from emp@to_11g ;
ERROR at line 1:
ORA-00942: table or view does not exist
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!