EXPDP - ORA-22923 (amount Of Data Specified In Streaming LOB Write Is 0) On The Export of TABLE_STATISTICS (Doc ID 1930202.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 10.1.0.2 to 12.1.0.2 [Release 10.1 to 12.1]
Oracle Database - Personal Edition - Version 10.1.0.2 to 12.1.0.2 [Release 10.1 to 12.1]
Oracle Database - Standard Edition - Version 10.1.0.2 to 12.1.0.2 [Release 10.1 to 12.1]
Enterprise Manager for Oracle Database - Version 10.1.0.2 to 12.1.0.6.0 [Release 10.1 to 12.1]
Information in this document applies to any platform.

Symptoms

1. You run a full database Export Data Pump job on your source database, and get the following errors:

$ expdp system/manager directory=my_dir dumpfile=expdp_f%.dmp logfile=expdp_f.log full=y parallel=6

Export: Release 11.2.0.3.0 - Production on Mon Sep 22 15:49:05 2014
Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Starting "SYSTEM"."SYS_EXPORT_FULL_01":  system/******** directory=my_dir dumpfile=expdp_f%.dmp logfile=expdp_f.log full=y parallel=6
Estimate in progress using BLOCKS method...
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 1.680 GB
Processing object type DATABASE_EXPORT/TABLESPACE
...
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/STATISTICS/TABLE_STATISTICS
ORA-39126: Worker unexpected fatal error in KUPW$WORKER.FETCH_XML_OBJECTS [TABLE_STATISTICS]
ORA-22923: amount of data specified in streaming LOB write is 0
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPW$WORKER", line 9001
----- PL/SQL Call Stack -----
 object      line  object
 handle    number  name
3f98e3c58     20462  package body SYS.KUPW$WORKER
3f98e3c58      9028  package body SYS.KUPW$WORKER
3f98e3c58     10935  package body SYS.KUPW$WORKER
3f98e3c58      2728  package body SYS.KUPW$WORKER
3f98e3c58      9697  package body SYS.KUPW$WORKER
3f98e3c58      1775  package body SYS.KUPW$WORKER
408931f08         2  anonymous block
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/STATISTICS/TABLE_STATISTICS
ORA-39126: Worker unexpected fatal error in KUPW$WORKER.FETCH_XML_OBJECTS [TABLE_STATISTICS]
ORA-22923: amount of data specified in streaming LOB write is 0
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPW$WORKER", line 9001
----- PL/SQL Call Stack -----
 object      line  object
 handle    number  name
3f98e3c58     20462  package body SYS.KUPW$WORKER
3f98e3c58      9028  package body SYS.KUPW$WORKER
3f98e3c58     10935  package body SYS.KUPW$WORKER
3f98e3c58      2728  package body SYS.KUPW$WORKER
3f98e3c58      9697  package body SYS.KUPW$WORKER
3f98e3c58      1775  package body SYS.KUPW$WORKER
408931f08         2  anonymous block
Job "SYSTEM"."SYS_EXPORT_FULL_01" stopped due to fatal error at 15:52:05

2. The Export Data Pump Worker trace files, shows following details:

...

*** 2014-09-22 10:27:04.926
dbkedDefDump(): Starting a non-incident diagnostic dump (flags=0x0, level=3, mask=0x0)
----- Error Stack Dump -----
ORA-22923: amount of data specified in streaming LOB write is 0
----- Current SQL Statement for this session (sql_id=b6d3u73ywf5bz) -----
SELECT /*+rule*/ SYS_XMLGEN(VALUE(KU$), XMLFORMAT.createFormat2('T_STAT_T', '7')), 0 ,KU$.BASE_OBJ.NAME ,KU$.BASE_OBJ.OWNER_NAME ,KU$.BASE_OBJ.TYPE_NAME ,'TABLE_STATISTICS' FROM SYS.KU$_TAB_STATS_VIEW KU$ WHERE NOT BITAND(KU$.BASE_OBJ.FLAGS,128)!=0 AND   KU$.OBJ_NUM IN (SELECT * FROM TABLE(DBMS_METADATA.FETCH_OBJNUMS(100001))) AND   KU$.BASE_OBJ.OWNER_NAME LIKE '%'
----- PL/SQL Stack -----
----- PL/SQL Call Stack -----
 object      line  object
 handle    number  name
3f9fa96d8      3228  package body SYS.DBMS_METADATA
3f9fa96d8      3817  package body SYS.DBMS_METADATA
3f9fa96d8      4124  package body SYS.DBMS_METADATA
3f9fa96d8      7411  package body SYS.DBMS_METADATA
408347e70     10683  package body SYS.KUPW$WORKER
408347e70      2728  package body SYS.KUPW$WORKER
408347e70      9697  package body SYS.KUPW$WORKER
408347e70      1775  package body SYS.KUPW$WORKER
4083cf738         2  anonymous block

...

 

Cause

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 hundreds of Community platforms