My Oracle Support Banner

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: 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


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.