Get ORA-942 When Creating Mview Over Dblink When Double Quotes Used In Connect To Clause
Last updated on OCTOBER 20, 2011
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
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms