My Oracle Support Banner

Output Cuts in the Middle of Words when Using Dbms_metadata.Get_ddl (Doc ID 391337.1)

Last updated on AUGUST 12, 2020

Applies to:

SQL*Plus - Version to [Release 9.2 to 12.1]
Information in this document applies to any platform.


When using the dbms_medadata.get_ddl to obtain the data definition language used to create the object, the output returns lines randomly truncated in the middle of words at the end of the line regardless of the linesize set (i.e. ENAB LE, etc).

For Example:


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

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