My Oracle Support Banner

Diagnosing ORA-12015 Fast Refresh Materialized View / Complex Queries (Doc ID 179466.1)

Last updated on NOVEMBER 07, 2023

Applies to:

Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Oracle Database Cloud Service - Version N/A and later
Information in this document applies to any platform.

Purpose

 

The purpose of this article is to provide a step by step guide to diagnosing the following error message, when users are attempting to refresh read
only or updatable materialized views / snapshots :

  ORA-12015: "cannot create a fast refresh snapshot from a complex query"
  ORA-12015: "cannot create fast refresh materialized view from a complex query"

     Cause: Neither ROWIDs and nor primary key constraints are supported for complex queries.
     Action: Reissue the command with the REFRESH FORCE or REFRESH COMPLETE option or create a simple materialized view.

Troubleshooting Steps

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.