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:Oracle Database - Enterprise Edition - Version 220.127.116.11 and later
Information in this document applies to any platform.
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.
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.
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