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!

EXPDP hangs on UDE-00005: unexpected End-Of-File encountered while reading input

DeepCMar 23 2020

Started export  three expdp commands. All three initially in wait state for a long time and after sometime one expdp the error UDE-00005: unexpected End-Of-File encountered while reading input and then started progressing - I can see one of the expdp has not started exporting any objects yet, even it's already over 45min.

One expdp --

dbauser/********@mydb JOB_NAME=exp_MYSCHEMA_transfer PARALLEL=8 CONTENT=ALL DIRECTORY=MY_DIRECTORY DUMPFILE=MYFILE_transfer_%U.d

mp SCHEMAS=MYSCHEMA,MYSCHEMA1 EXCLUDE=STATISTICS LOGFILE=MYSCHEMA_transfer.log 

Schätzung erfolgt mit Methode BLOCKS...

Objekttyp SCHEMA_EXPORT/TABLE/TABLE_DATA wird verarbeitet

;;; UDE-00005: unexpected End-Of-File encountered while reading input

Gesamte Schätzung mit BLOCKS Methode: 277.2 GB

Objekttyp SCHEMA_EXPORT/USER wird verarbeitet

Objekttyp SCHEMA_EXPORT/SYSTEM_GRANT wird verarbeitet

Objekttyp SCHEMA_EXPORT/ROLE_GRANT wird verarbeitet

Objekttyp SCHEMA_EXPORT/DEFAULT_ROLE wird verarbeitet

Objekttyp SCHEMA_EXPORT/TABLESPACE_QUOTA wird verarbeitet

Objekttyp SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA wird verarbeitet

Objekttyp SCHEMA_EXPORT/SYNONYM/SYNONYM wird verarbeitet

. . "MYSCHEMA"."BCKP_EVRS_20181130"               488.4 MB 6307057 Zeilen exportiert

another expdp - this one is waiting

Export: Release 11.2.0.3.0 - Production on Mo Mrz 23 12:42:51 2020

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

;;;

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

With the Partitioning, Oracle Label Security, OLAP, Data Mining

and Real Application Testing options

dbauser/********@mydb JOB_NAME=exp_MY2NDSCHEMA_transfer PARALLEL=8 CONTENT=ALL DIRECTORY=MY_DIRECTORY DUMPFILE=MY2NDSCHEMA_transfer_%U.dmp SCHEMAS=MY2NDSCHEMA,MY2NDSCHEMA_2 EXCLUDE=STATISTICS LOGFILE=MY2NDSCHEMA_transfer.log 

Schätzung erfolgt mit Methode BLOCKS...

Objekttyp SCHEMA_EXPORT/TABLE/TABLE_DATA wird verarbeitet

Can we ignore the error, because export is progressing and creating 8 dump files? Why expdp throwing the error- we are not redirecting any input/outpit

Comments
Post Details
Added on Mar 23 2020
0 comments
2,171 views