My Oracle Support Banner

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 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

To view full details, 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 a vibrant support community of peers and Oracle experts.