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

Last updated on JANUARY 05, 2023

Applies to:

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

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