ORA-12008 and ORA-00942 Error Reported During Materialized View Refresh Across Schema
(Doc ID 2559390.1)
Last updated on FEBRUARY 28, 2021
Applies to:Oracle Database - Standard Edition - Version 126.96.36.199 and later
Information in this document applies to any platform.
When usera has a base table, userb has a materialized view based on usera's table.
userc executed userb's materialized view, and failed with ORA-12008 and ORA-00942.
The test case is as following:
Event when using sysdba to execute userb's materialized view, still 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