i have a problem when i try to export ...

Connected to: Oracle Database 11g Express Edition Release - 64bit Production
Export done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set

About to export specified users ...
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user SEMESU
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user SEMESU
About to export SEMESU's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
EXP-00056: ORACLE error 12704 encountered
ORA-12704: character set mismatch
EXP-00000: Export terminated unsuccessfully

anyone? (i'll apreciatte)

  • Is exp started from the database server? What is the output of echo $NLS_LANG on the client? If you try expdp instead of exp does an error occur , too? What are the parameters of your exp command?
    – miracle173
    May 16, 2014 at 6:03

1 Answer 1


You will have to export NLS_LANG env variable like mentioned here http://docs.oracle.com/cd/E11882_01/server.112/e16604/ch_eleven.htm#sthref1049 If you use expdp, you don't need to do this...

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.