ORA-12018 & ORA-00942: Upon Fast Refresh of a Materialized View
(Doc ID 92350.1)
Last updated on AUGUST 04, 2018
Applies to:Oracle Database - Enterprise Edition - Version 126.96.36.199 to 188.8.131.52 [Release 8.1.7 to 11.1]
Information in this document applies to any platform.
You attempting to perform a FAST REFRESH of a Materialized View and are receiving the following errors:
Cause: The refresh operations for the indicated snapshot could not be regenerated due to errors. See following error text.
Action: Correct the indicated problem and repeat the operation.
This can occur if you CREATE a Materialized View as FAST REFRESH.
The mview is in the same database as the master table however it's being created in a different schema than the master table. You can perform a complete refresh with no errors however the fast refresh fails with the above errors. You have created a mview log owned by the same owner as the master table. You have granted select priveleges on the master table to the schema which owns the mview.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!