How to resolve 'EXP-00000: Export terminated unsuccessfully' error encountered during Oracle Export in Thor Xellerate
2 years ago
Originally Published: 2005-01-28
Article Number
000060377
Applies To
Oracle 9i
Thor Xellerate 7.2.4
Issue
How to resolve "EXP-00000: Export terminated unsuccessfully" error encountered during Oracle Export in Thor Xellerate
Received the following error while trying to export data from a Oracle database:

EXP SYSADM/xxxx file="file2.dmp" log="junk2.log" >

Connected to: Oracle9i Enterprise Edition Release 9.2.0.2.0 - 64bit Production
With the Partitioning option
JServer Release 9.2.0.2.0 - Production
Export done in WE8ISO8859P1 character set and AL16UTF16 NCHAR character set
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user SYSADM
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user SYSADM
About to export SYSADM's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
EXP-00056: ORACLE error 31600 encountered
ORA-31600: invalid input value EMIT_SCHEMA for parameter NAME in function SET_TRANSFORM_PARAM
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
ORA-06512: at "SYS.DBMS_METADATA_INT", line 3926
ORA-06512: at "SYS.DBMS_METADATA_INT", line 4050
ORA-06512: at "SYS.DBMS_METADATA", line 836
ORA-06512: at line 1
EXP-00000: Export terminated unsuccessfully
Resolution
There may be a performance problem when Oracle is under load and async io is enabled in the Oracle database.