Get ORA-942 When Creating Mview Over Dblink When Double Quotes Used In Connect To Clause

(Doc ID 602390.1)

Last updated on OCTOBER 20, 2011

Applies to:

Oracle Server - Enterprise Edition - Version: and later   [Release: 10.2 and later ]
Information in this document applies to any platform.


Creating an mview over a dblink fails with ORA-942.

Testcase SQL:

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