MVIEW Creation Fails With ORA-12015 In 19c But Not In 18c
(Doc ID 2778772.1)
Last updated on JULY 20, 2024
Applies to:
Oracle Database - Enterprise Edition - Version 19.11.0.0.0 and laterInformation in this document applies to any platform.
Symptoms
We are having issue creating MV in Oracle 19c environment. The MV can be created just fine in 18c. Attached is the DDL and output of the error.
Problem creating 19c MV when:
1. Query is selecting from a view
2. Query has sub query
The attached file has an example for no. 1 but we would like to understand why both works only in our 18c environment but not 19c
Changes
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! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |