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