My Oracle Support Banner

Generated DDL is Incomplete for Tables from a Different Schema (Doc ID 2758180.1)

Last updated on AUGUST 02, 2023

Applies to:

Oracle SQL Developer - Version 20.2 and later
Information in this document applies to any platform.

Goal

SQL Developer 19.4 shows this comment when clicking on SQL tab for a table from a different schema.

  -- Unable to render TABLE DDL for object <SCHEMA_NAME>.<TABLE_NAME> with DBMS_METADATA attempting internal generator.

When attempting the same in SQL Developer 20.4, only the grants are shown.

Why does this happen?
 

Solution

To view full details, 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 a vibrant support community of peers and Oracle experts.