My Oracle Support Banner

Dbms_metadata.get_ddl Getting ORA-22923: Amount Of Data Specified In Streaming LOB Write Is 0 (Doc ID 2501416.1)

Last updated on JULY 02, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.4 and later
Information in this document applies to any platform.

Goal

SQL>select dbms_metadata.get_ddl('TABLE','<TABLE_NAME>', '<SCHEMA_NAME>') from dual;
ERROR:
ORA-22923: amount of data specified in streaming LOB write is 0
ORA-06512: at "SYS.DBMS_METADATA", line 1548
ORA-06512: at "SYS.DBMS_METADATA", line 1585
ORA-06512: at "SYS.DBMS_METADATA", line 1902
ORA-06512: at "SYS.DBMS_METADATA", line 2793
ORA-06512: at "SYS.DBMS_METADATA", line 4333
ORA-06512: at line 1

no rows selected

SQL>Analyze table <SCHEMA_NAME>.<TABLE_NAME> validate structure cascade online;
Analyze table <SCHEMA_NAME>.<TABLE_NAME> validate structure cascade online
*
ERROR at line 1:
ORA-14508: specified VALIDATE INTO table not found
 

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!


In this Document
Goal
Solution


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