My Oracle Support Banner

Materialized View Cannot Generate DDL (Doc ID 1096930.1)

Last updated on AUGUST 04, 2018

Applies to:

Oracle SQL Developer - Version 1.5.1 to 3.1
Information in this document applies to any platform.
***Checked for relevance on 24-Jul-2013***

Symptoms

Problem: 
======== 
User 1 - has ownership of the Materialized view 
User 2 - with permissions can see the Materialized view but when they try to 
select SQL to view the DDL comes up with the error: generation of ddl failed 

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


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