ORA-00980 Occurs When Creating Materialized View from Remote Synonym While that Synonym points to a Remote Table (Doc ID 2550447.1)

Last updated on OCTOBER 16, 2019

Applies to:

Symptoms

Customer want to create a materialized view across two dblinks,
image is : DB#1-->(DBLINK1)-->DB#2-->(DBLINK2)-->DB#3

At DB#3, executed:

Here the DBLINK1 points to DB#2.

To summarize:

We want to create a materialized view MV01 at DB#1 by accesing an object on DB#2: U1.TAB01@DBLINK1,
U1.TAB01 at DB#1 is a synonym , who points to object on DB#3 via DBLINK: U1.TAB01@DBLINK2, And we get ORA-00980 error and failed.

Cause

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