ORA-12018 & ORA-00942: Upon Fast Refresh of a Materialized View (Doc ID 92350.1)

Last updated on MAY 12, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 8.1.7.4 to 11.1.0.6 [Release 8.1.7 to 11.1]
Information in this document applies to any platform.

Symptoms

You attempting to perform a FAST REFRESH of a Materialized View and are receiving the following errors:

ORA-12018: following error encountered during code generation for %s . %s
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.

 

ORA-00942: See <Note 18536.1>



--OR--

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.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms