exp test/test file=test.dmp wner=test log=exp.log 出错 exp-00056: oracle error 29275 encountered ora-29275: partial multibyte character exp-00000: export terminated unsuccessfully 原因：字符集不一致 oracle@mdswebdb01:sqlplus/ as sysdba sql*
exp test/test file=test.dmp wner=test log=exp.log
出错
exp-00056: oracle error 29275 encountered
ora-29275: partial multibyte character
exp-00000: export terminated unsuccessfully
原因：字符集不一致
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, 2007, oracle.  all rights reserved.
connected to:
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
解决方法：
export nls_lang=american_america.al32utf8
再继续exp