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 FEBRUARY 09, 2022
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]
Oracle Database Cloud Schema Service - Version N/A and later
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/<pwd> 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
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
...
*** 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
...
Changes
Cause
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
Symptoms |
Changes |
Cause |
Solution |
References |