Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

data pump export problem

User_MF1OGDec 21 2022

the platfornm is oracle linux 7.9

;;;
Export: Release 19.0.0.0.0 - Production on Wed Dec 21 15:00:47 2022
Version 19.3.0.0.0

Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
;;;
Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Starting "SYS"."SYS_EXPORT_SCHEMA_11": "/******** AS SYSDBA" SCHEMAS=TEST_GEC DIRECTORY=TEST_DIR DUMPFILE=FADI11%U.dmp LOGFILE=FADI11.log exclude=statistics
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Processing object type SCHEMA_EXPORT/PACKAGE/PACKAGE_BODY
Processing object type SCHEMA_EXPORT/USER
Processing object type SCHEMA_EXPORT/SYSTEM_GRANT
Processing object type SCHEMA_EXPORT/ROLE_GRANT
Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
Processing object type SCHEMA_EXPORT/TABLESPACE_QUOTA
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/DB_LINK
Processing object type SCHEMA_EXPORT/SEQUENCE/SEQUENCE
Processing object type SCHEMA_EXPORT/TABLE/TABLE
Processing object type SCHEMA_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type SCHEMA_EXPORT/TABLE/COMMENT
Processing object type SCHEMA_EXPORT/TABLE/AUDIT_OBJ
Processing object type SCHEMA_EXPORT/PACKAGE/PACKAGE_SPEC
Processing object type SCHEMA_EXPORT/PACKAGE/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type SCHEMA_EXPORT/FUNCTION/FUNCTION
Processing object type SCHEMA_EXPORT/PROCEDURE/PROCEDURE
Processing object type SCHEMA_EXPORT/PACKAGE/COMPILE_PACKAGE/PACKAGE_SPEC/ALTER_PACKAGE_SPEC
Processing object type SCHEMA_EXPORT/FUNCTION/ALTER_FUNCTION
Processing object type SCHEMA_EXPORT/PROCEDURE/ALTER_PROCEDURE
Processing object type SCHEMA_EXPORT/VIEW/VIEW
Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT
Processing object type SCHEMA_EXPORT/TABLE/TRIGGER
. . exported "TEST_GEC"."LOV_ITEM" 56.46 MB 1119008 rows
. . exported "TEST_GEC"."QQQQ" 47.06 MB 25475 rows
. . exported "TEST_GEC"."EXPFULL" 46.78 MB 24295 rows
. . exported "TEST_GEC"."SYS_EXPORT_FULL_02" 46.69 MB 24272 rows
. . exported "TEST_GEC"."SYS_EXPORT_FULL_01" 46.60 MB 24253 rows
. . exported "TEST_GEC"."SYS_EXPORT_FULL_03" 45.66 MB 19690 rows
. . exported "TEST_GEC"."G_DICTIONARY" 447.8 KB 7364 rows
. . exported "TEST_GEC"."G_LABELS" 321.6 KB 4620 rows
. . exported "TEST_GEC"."LABELS" 183.9 KB 2301 rows
. . exported "TEST_GEC"."G_MESSAGE" 170.3 KB 1145 rows
. . exported "TEST_GEC"."IN_DRIVERS_DTL" 157.5 KB 3278 rows
. . exported "TEST_GEC"."UTS_CLNDR" 146.7 KB 1826 rows
. . exported "TEST_GEC"."G_FLAGS" 94.49 KB 2115 rows
. . exported "TEST_GEC"."LOV_COLONNE" 66.11 KB 523 rows
. . exported "TEST_GEC"."LANG_SQL_HELP" 42.29 KB 269 rows
. . exported "TEST_GEC"."LOV_BLOCK" 50.64 KB 1551 rows
. . exported "TEST_GEC"."LOV_LOV" 30.77 KB 70 rows
. . exported "TEST_GEC"."S_PROGRAM" 27.76 KB 156 rows
. . exported "TEST_GEC"."G_DIC_LABEL" 27.49 KB 933 rows
. . exported "TEST_GEC"."FF_ACLST" 25.04 KB 196 rows
. . exported "TEST_GEC"."IN_MATERIAL" 27.14 KB 9 rows
. . exported "TEST_GEC"."G_CNTRY" 23.62 KB 249 rows
. . exported "TEST_GEC"."LOV_COLONNE_LOV" 23.72 KB 180 rows
. . exported "TEST_GEC"."IN_APPREVEORDER" 22.86 KB 13 rows
. . exported "TEST_GEC"."IN_TRANSORDER" 22.17 KB 11 rows
. . exported "TEST_GEC"."IN_RETURN" 21.97 KB 1 rows
. . exported "TEST_GEC"."S_GROUPDTL" 19.85 KB 258 rows
. . exported "TEST_GEC"."FF_YACCB" 19.72 KB 196 rows
. . exported "TEST_GEC"."G_CITY" 18.89 KB 400 rows
. . exported "TEST_GEC"."DUMMY1" 18.10 KB 118 rows
. . exported "TEST_GEC"."IN_SALESORDER" 19.03 KB 1 rows
. . exported "TEST_GEC"."IN_SALESORDER_TMP" 19.14 KB 1 rows
. . exported "TEST_GEC"."IN_CUSTOMERS" 18.20 KB 2 rows
. . exported "TEST_GEC"."IN_RETURN_DTL" 17.57 KB 1 rows
. . exported "TEST_GEC"."IN_APPREVEORDER_TMP" 16.91 KB 2 rows
. . exported "TEST_GEC"."G_CURR_COD" 15.22 KB 190 rows
. . exported "TEST_GEC"."Machines" 15.51 KB 2 rows
. . exported "TEST_GEC"."FA_FOBLG" 15.31 KB 2 rows
. . exported "TEST_GEC"."LOV_MODULE" 14.72 KB 600 rows
. . exported "TEST_GEC"."IN_SALESORDER_DTL" 15.12 KB 1 rows
. . exported "TEST_GEC"."IN_SUPL_MAS" 13.40 KB 1 rows
. . exported "TEST_GEC"."G_BANKCD" 12.60 KB 27 rows
. . exported "TEST_GEC"."G_BANKCD00" 12.67 KB 27 rows
. . exported "TEST_GEC"."G_BRNCH" 12.07 KB 3 rows
. . exported "TEST_GEC"."G_COMCOD" 11.85 KB 1 rows
. . exported "TEST_GEC"."IN_CUSTOMERS1" 11.99 KB 6 rows
. . exported "TEST_GEC"."S_FUNCTION" 10.95 KB 33 rows
. . exported "TEST_GEC"."S_MAINSEC" 11.07 KB 3 rows
. . exported "TEST_GEC"."G_SELECT" 10.49 KB 48 rows
. . exported "TEST_GEC"."G_TRNCODE" 10.56 KB 53 rows
. . exported "TEST_GEC"."UTIL_PREFS" 10.07 KB 3 rows
. . exported "TEST_GEC"."IN_CUSTOMERS_TEL" 10.37 KB 2 rows
. . exported "TEST_GEC"."FF_MNYER" 10.33 KB 1 rows
. . exported "TEST_GEC"."G_PARAMETERS" 9.539 KB 1 rows
. . exported "TEST_GEC"."S_SEQ_VALUE" 9.273 KB 9 rows
. . exported "TEST_GEC"."S_SYSTEM" 9.078 KB 5 rows
. . exported "TEST_GEC"."IN_DRIVERS" 8.914 KB 6 rows
. . exported "TEST_GEC"."G_SEQ_CNTRL" 8.531 KB 1 rows
. . exported "TEST_GEC"."S_APPL" 8.148 KB 5 rows
. . exported "TEST_GEC"."IN_CUSTOMERS_LIMIT" 7.984 KB 2 rows
. . exported "TEST_GEC"."IN_PRICE_DTL" 7.937 KB 1 rows
. . exported "TEST_GEC"."FF_CRATE" 7.914 KB 1 rows
. . exported "TEST_GEC"."UNICODE_VALUES" 8.414 KB 276 rows
. . exported "TEST_GEC"."G_COLORS" 7.578 KB 82 rows
. . exported "TEST_GEC"."G_DESTRCT" 7.546 KB 37 rows
. . exported "TEST_GEC"."G_QUERY" 7.406 KB 5 rows
. . exported "TEST_GEC"."IN_DET_COD" 7.507 KB 3 rows
. . exported "TEST_GEC"."SYS_KEYSHELP" 7.304 KB 27 rows
. . exported "TEST_GEC"."G_BNKBRNACNO" 7.812 KB 162 rows
. . exported "TEST_GEC"."G_FOLDERS" 7.218 KB 10 rows
. . exported "TEST_GEC"."G_MENU_LABELS" 7.242 KB 23 rows
. . exported "TEST_GEC"."GRAPHICS_TABLE" 6.632 KB 6 rows
. . exported "TEST_GEC"."G_PRINTERS" 6.789 KB 5 rows
. . exported "TEST_GEC"."CONVERT_CHAR" 7.070 KB 134 rows
. . exported "TEST_GEC"."G_MONTHS" 6.656 KB 12 rows
. . exported "TEST_GEC"."IN_SCAL_COD" 6.687 KB 12 rows
. . exported "TEST_GEC"."S_GROUPS" 6.539 KB 3 rows
. . exported "TEST_GEC"."MONTH_LDBAM_08" 6.687 KB 7 rows
. . exported "TEST_GEC"."IN_MAT_M_COD" 6.085 KB 3 rows
. . exported "TEST_GEC"."IN_MA_COD" 6.070 KB 3 rows
. . exported "TEST_GEC"."S_USERG" 6.054 KB 3 rows
. . exported "TEST_GEC"."IN_STORES" 6.093 KB 3 rows
. . exported "TEST_GEC"."APS_EMP_TIME" 5.976 KB 1 rows
. . exported "TEST_GEC"."G_LANGUAGE" 5.507 KB 1 rows
. . exported "TEST_GEC"."AP_EMPLOYEES" 0 KB 0 rows
. . exported "TEST_GEC"."AP_MSG" 0 KB 0 rows
. . exported "TEST_GEC"."CHAT" 0 KB 0 rows
. . exported "TEST_GEC"."ENT_USER" 0 KB 0 rows
. . exported "TEST_GEC"."FACCDR_12" 0 KB 0 rows
. . exported "TEST_GEC"."FA_DEBITS" 0 KB 0 rows
. . exported "TEST_GEC"."FA_OBLAB" 0 KB 0 rows
. . exported "TEST_GEC"."FF_DFTRN" 0 KB 0 rows
. . exported "TEST_GEC"."FF_DFTRNS" 0 KB 0 rows
. . exported "TEST_GEC"."FF_IOCHK" 0 KB 0 rows
. . exported "TEST_GEC"."FF_MFTRN" 0 KB 0 rows
. . exported "TEST_GEC"."FF_MFTRNS" 0 KB 0 rows
. . exported "TEST_GEC"."FF_MNBAL" 0 KB 0 rows
. . exported "TEST_GEC"."G_ACTIVITIES" 0 KB 0 rows
. . exported "TEST_GEC"."G_AD_ACCOUNTS" 0 KB 0 rows
. . exported "TEST_GEC"."G_BNKBRN" 0 KB 0 rows
. . exported "TEST_GEC"."G_CATEGORIES" 0 KB 0 rows
. . exported "TEST_GEC"."G_CHAR" 0 KB 0 rows
. . exported "TEST_GEC"."G_CODGRP" 0 KB 0 rows
. . exported "TEST_GEC"."G_CONTROL" 0 KB 0 rows
. . exported "TEST_GEC"."G_DEPATMNT" 0 KB 0 rows
. . exported "TEST_GEC"."G_DONER" 0 KB 0 rows
. . exported "TEST_GEC"."G_EQPCOD" 0 KB 0 rows
. . exported "TEST_GEC"."G_ESTABLISHMENTS" 0 KB 0 rows
. . exported "TEST_GEC"."G_EXAD_ACCOUNTS" 0 KB 0 rows
. . exported "TEST_GEC"."G_GROUPS" 0 KB 0 rows
. . exported "TEST_GEC"."G_HOFFICE" 0 KB 0 rows
. . exported "TEST_GEC"."G_ISS_EST" 0 KB 0 rows
. . exported "TEST_GEC"."G_JOB_W_COD" 0 KB 0 rows
. . exported "TEST_GEC"."G_MATCOD" 0 KB 0 rows
. . exported "TEST_GEC"."G_MEDALS_CODE" 0 KB 0 rows
. . exported "TEST_GEC"."G_MFILDC" 0 KB 0 rows
. . exported "TEST_GEC"."G_PROCOD" 0 KB 0 rows
. . exported "TEST_GEC"."G_REASON_CODE" 0 KB 0 rows
. . exported "TEST_GEC"."G_RUBCOD" 0 KB 0 rows
. . exported "TEST_GEC"."G_SECENT" 0 KB 0 rows
. . exported "TEST_GEC"."G_SECREG" 0 KB 0 rows
. . exported "TEST_GEC"."G_SFILDC" 0 KB 0 rows
. . exported "TEST_GEC"."G_STOR_TYP" 0 KB 0 rows
. . exported "TEST_GEC"."G_TRN_SRC" 0 KB 0 rows
. . exported "TEST_GEC"."G_UNT_CODE" 0 KB 0 rows
. . exported "TEST_GEC"."G_UNT_CODE_CONV" 0 KB 0 rows
. . exported "TEST_GEC"."IN_APPREVEORDERS" 0 KB 0 rows
. . exported "TEST_GEC"."IN_APPREVEORDERSS" 0 KB 0 rows
. . exported "TEST_GEC"."IN_APPREVEORDER_DTL" 0 KB 0 rows
. . exported "TEST_GEC"."IN_APPREVEORDER_DTL_FINAL" 0 KB 0 rows
. . exported "TEST_GEC"."IN_DRIVER" 0 KB 0 rows
. . exported "TEST_GEC"."IN_PURCHASES" 0 KB 0 rows
. . exported "TEST_GEC"."IN_PURCHASES_DTL" 0 KB 0 rows
. . exported "TEST_GEC"."IN_PURCHASES_DTL_RETURN" 0 KB 0 rows
. . exported "TEST_GEC"."IN_PURCHASES_RETURN" 0 KB 0 rows
. . exported "TEST_GEC"."IN_P_SUPL_MAS" 0 KB 0 rows
. . exported "TEST_GEC"."IN_RETURNS2" 0 KB 0 rows
. . exported "TEST_GEC"."IN_STORES_DTL" 0 KB 0 rows
. . exported "TEST_GEC"."IN_SUPL_DMAS" 0 KB 0 rows
. . exported "TEST_GEC"."IN_SUPPORT" 0 KB 0 rows
. . exported "TEST_GEC"."IN_SUPPORTS1" 0 KB 0 rows
. . exported "TEST_GEC"."IN_SUPPORTS2" 0 KB 0 rows
. . exported "TEST_GEC"."IN_SUPPORTS3" 0 KB 0 rows
. . exported "TEST_GEC"."IN_SUPPORT_DTL" 0 KB 0 rows
. . exported "TEST_GEC"."IN_SUP_DMAS" 0 KB 0 rows
. . exported "TEST_GEC"."IN_SUP_MAS" 0 KB 0 rows
. . exported "TEST_GEC"."IN_TRANSORDER_DTL" 0 KB 0 rows
. . exported "TEST_GEC"."IN_TRANSORDER_DTL_FINAL" 0 KB 0 rows
. . exported "TEST_GEC"."IN_TRANSORDER_DTL_PURCHASES" 0 KB 0 rows
. . exported "TEST_GEC"."IN_TRANS_DTL" 0 KB 0 rows
. . exported "TEST_GEC"."IN_TRANS_MST" 0 KB 0 rows
. . exported "TEST_GEC"."MESSAGES" 0 KB 0 rows
. . exported "TEST_GEC"."MONTH_LDBAM" 0 KB 0 rows
. . exported "TEST_GEC"."MONTH_LDBAM08" 0 KB 0 rows
. . exported "TEST_GEC"."MONTH_LDBAM09" 0 KB 0 rows
. . exported "TEST_GEC"."MONTH_LDBAMS" 0 KB 0 rows
. . exported "TEST_GEC"."MONTH_LDBAMSS" 0 KB 0 rows
. . exported "TEST_GEC"."MONTH_LDBAM_00" 0 KB 0 rows
. . exported "TEST_GEC"."MONTH_LDBAM_01" 0 KB 0 rows
. . exported "TEST_GEC"."MONTH_LDBAM_02" 0 KB 0 rows
. . exported "TEST_GEC"."MONTH_LDBAM_03" 0 KB 0 rows
. . exported "TEST_GEC"."MONTH_LDBAM_04" 0 KB 0 rows
. . exported "TEST_GEC"."MONTH_LDBAM_05" 0 KB 0 rows
. . exported "TEST_GEC"."MONTH_LDBAM_06" 0 KB 0 rows
. . exported "TEST_GEC"."MONTH_LDBAM_07" 0 KB 0 rows
. . exported "TEST_GEC"."MONTH_LDBAM_09" 0 KB 0 rows
. . exported "TEST_GEC"."MONTH_REPORTS" 0 KB 0 rows
. . exported "TEST_GEC"."MONTH_REPORTS1" 0 KB 0 rows
. . exported "TEST_GEC"."MONTH_REPORTS2" 0 KB 0 rows
. . exported "TEST_GEC"."MONTH_REPORTS3" 0 KB 0 rows
. . exported "TEST_GEC"."MY_COOKIES" 0 KB 0 rows
. . exported "TEST_GEC"."REP_DICTIONARY" 0 KB 0 rows
. . exported "TEST_GEC"."REP_DIC_LABEL" 0 KB 0 rows
. . exported "TEST_GEC"."SALES" 0 KB 0 rows
. . exported "TEST_GEC"."S_FUN_NAME" 0 KB 0 rows
. . exported "TEST_GEC"."S_GRPDTLITMS" 0 KB 0 rows
. . exported "TEST_GEC"."S_LOGF" 0 KB 0 rows
. . exported "TEST_GEC"."S_SEQ_CNTL" 0 KB 0 rows
. . exported "TEST_GEC"."S_SEQ_VAL" 0 KB 0 rows
ORA-39126: Worker unexpected fatal error in KUPW$WORKER.UNLOAD_DATA [TABLE_DATA:"SYS"."SYS_EXPORT_SCHEMA_11"]
ORA-00604: error occurred at recursive SQL level 2
ORA-31011: XML parsing failed
ORA-19213: error occurred in XML processing at lines 1
LPX-00007: unexpected end-of-file encountered
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPW$WORKER", line 12613
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.DBMS_STATS", line 40751
ORA-06512: at "SYS.DBMS_STATS", line 40035
ORA-06512: at "SYS.DBMS_STATS", line 1872
ORA-06512: at "SYS.DBMS_STATS", line 39940
ORA-06512: at "SYS.DBMS_STATS", line 40183
ORA-06512: at "SYS.DBMS_STATS", line 40732
ORA-06512: at "SYS.KUPW$WORKER", line 4225
----- PL/SQL Call Stack -----
object line object
handle number name
0x80af32a8 33476 package body SYS.KUPW$WORKER.WRITE_ERROR_INFORMATION
0x80af32a8 12641 package body SYS.KUPW$WORKER.DETERMINE_FATAL_ERROR
0x80af32a8 4642 package body SYS.KUPW$WORKER.UNLOAD_DATA
0x80af32a8 13767 package body SYS.KUPW$WORKER.DISPATCH_WORK_ITEMS
0x80af32a8 2429 package body SYS.KUPW$WORKER.MAIN
0x7206ffd8 2 anonymous block
KUPW: Method: 1
KUPW: Parallel: 1
KUPW: Creation level: 0
KUPW: Sequence number: 0
BULK COLLECT
BULK COLLECT
KUPW: In procedure BUILD_OBJECT_STRINGS - non-base info
KUPW: In PROCESS_TABLE_DATA_METRICS
DBMS_STATS.GATHER_TABLE_STATS
KUPW: In procedure DETERMINE_FATAL_ERROR with ORA-00604: error occurred at recursive SQL level 2
ORA-06512: at "SYS.DBMS_STATS", line 40751
ORA-06512: at "SYS.DBMS_STATS", line 40035
ORA-31011: XML parsing failed
ORA-19213: error occurred in XML processing at lines 1
LPX-00007: unexpected end-of-file encountered
ORA-06512: at "SYS.DBMS_STATS", line 1872
ORA-06512: at "SYS.DBMS_STATS", line 39940
ORA-06512: at "SYS.DBMS_STATS", line 40183
ORA-06512: at "SYS.DBMS_STATS", line 40732
ORA-39126: Worker unexpected fatal error in KUPW$WORKER.UNLOAD_DATA [TABLE_DATA:"SYS"."SYS_EXPORT_SCHEMA_11"]
ORA-00604: error occurred at recursive SQL level 2
ORA-31011: XML parsing failed
ORA-19213: error occurred in XML processing at lines 1
LPX-00007: unexpected end-of-file encountered
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPW$WORKER", line 12613
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.DBMS_STATS", line 40751
ORA-06512: at "SYS.DBMS_STATS", line 40035
ORA-06512: at "SYS.DBMS_STATS", line 1872
ORA-06512: at "SYS.DBMS_STATS", line 39940
ORA-06512: at "SYS.DBMS_STATS", line 40183
ORA-06512: at "SYS.DBMS_STATS", line 40732
ORA-06512: at "SYS.KUPW$WORKER", line 4225
----- PL/SQL Call Stack -----
object line object
handle number name
0x80af32a8 33476 package body SYS.KUPW$WORKER.WRITE_ERROR_INFORMATION
0x80af32a8 12641 package body SYS.KUPW$WORKER.DETERMINE_FATAL_ERROR
0x80af32a8 4642 package body SYS.KUPW$WORKER.UNLOAD_DATA
0x80af32a8 13767 package body SYS.KUPW$WORKER.DISPATCH_WORK_ITEMS
0x80af32a8 2429 package body SYS.KUPW$WORKER.MAIN
0x7206ffd8 2 anonymous block
KUPW: Method: 1
KUPW: Parallel: 1
KUPW: Creation level: 0
KUPW: Sequence number: 0
BULK COLLECT
BULK COLLECT
KUPW: In procedure BUILD_OBJECT_STRINGS - non-base info
KUPW: In PROCESS_TABLE_DATA_METRICS
DBMS_STATS.GATHER_TABLE_STATS
KUPW: In procedure DETERMINE_FATAL_ERROR with ORA-00604: error occurred at recursive SQL level 2
ORA-06512: at "SYS.DBMS_STATS", line 40751
ORA-06512: at "SYS.DBMS_STATS", line 40035
ORA-31011: XML parsing failed
ORA-19213: error occurred in XML processing at lines 1
LPX-00007: unexpected end-of-file encountered
ORA-06512: at "SYS.DBMS_STATS", line 1872
ORA-06512: at "SYS.DBMS_STATS", line 39940
ORA-06512: at "SYS.DBMS_STATS", line 40183
ORA-06512: at "SYS.DBMS_STATS", line 40732
Job "SYS"."SYS_EXPORT_SCHEMA_11" stopped due to fatal error at Wed Dec 21 15:01:50 2022 elapsed 0 00:00:58

Comments

Post Details

Added on Dec 21 2022
5 comments
440 views