My Oracle Support Banner

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.