Exptesttestfiletest. dmpwnertestlogexp. log error EXP-00056: Oracleerror29275encounteredORA-29275: partialmultibytecharacterEXP-00000: Exportterminatedunsuccessfully cause: Character Set inconsistent Oracle @ MDSWEBDB01: sqlplusassysdbaSQL *
Exp test/test file = test. dmp wner = test log = exp. log error EXP-00056: Oracle error 29275 encountered ORA-29275: partial multibyte character EXP-00000: Export terminated unsuccessfully cause: character Set inconsistent Oracle @ MDSWEBDB01: sqlplus/as sysdba SQL *
Exp test/test file = test. dmp wner = test log = exp. log
Error
EXP-00056: Oracle error 29275 encountered
ORA-29275: partial multibyte character.
EXP-00000: Export terminated unsuccessfully
Cause: inconsistent character sets
Oracle @ MDSWEBDB01:> sqlplus/as sysdba
SQL * Plus: Release 11.1.0.6.0-Production on Wed Aug 29 15:35:12 2012
Copyright (c) 1982,200 7, Oracle. All rights reserved.
Connected:
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0-64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> select value from NLS_DATABASE_PARAMETERS where parameter = 'nls _ CHARACTERSET ';
VALUE
--------------------------------------------------------------------------------
AL32UTF8
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.1.0.6.0-64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Oracle @ MDSWEBDB01:> echo $ NLS_LANG
AMERICAN_AMERICA.UTF8
Solution:
Export NLS_LANG = AMERICAN_AMERICA.AL32UTF8
Continue exp