ORA-12018 & ORA-00942: Upon Fast Refresh of a Materialized View
Last updated on MAY 12, 2017
Applies to:Oracle Database - Enterprise Edition - Version 22.214.171.124 to 126.96.36.199 [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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms