Issue while Refreshing A Materialized View On A Synonym Through A Dblink
(Doc ID 2966241.1)
Last updated on JULY 20, 2024
Applies to:
Oracle Database - Enterprise Edition - Version 19.16.0.0.0 and laterInformation in this document applies to any platform.
Symptoms
Mview definition not updated when the synonym definition changes, on which it is based.
Details:
Synonym A in database A that points A1 table and the other day synonym A needs to be pointed a A2 table.
On a database B, Materialized View is created that is based on synonym A from database A through a dblink, synonym A then points to table A1. The data in the A1 table is seen in the materialized view.
The next day synonym A points to table A2, but the materialized view has the data of table A1 seen when it is expected to see the data in table A2.
Changes
Changes in the synonym definition
Cause
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
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |