Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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

Connected to: Oracle Database 11g Express Edition Release 11.2.0.2.0 - 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)

share|improve this question
    
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 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...

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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