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 JANUARY 05, 2023

Applies to:

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


SQL>select dbms_metadata.get_ddl('TABLE','<TABLE_NAME>', '<SCHEMA_NAME>') from dual;
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


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.