Materialized View Cannot Generate DDL (Doc ID 1096930.1)

Last updated on OCTOBER 27, 2016

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

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 hundreds of Community platforms