EXP备份数据库的时候报错EXP-00091：

Connected to: Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options
Export done in US7ASCII character set and AL16UTF16 NCHAR character set
server uses ZHS16GBK character set (possible charset conversion)

About to export specified users ...
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user CCZQ
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user CCZQ
About to export CCZQ's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
. about to export CCZQ's tables via Conventional Path ...
. . exporting table                        A000000        158 rows exported
. . exporting table                             A5     356752 rows exported
. . exporting table                           AAAA        884 rows exported
. . exporting table                         AAA_01    6958730 rows exported
. . exporting table                            ABC       1132 rows exported
. . exporting table BACKINNERBASEROLEUSERINFO_HIS        216 rows exported
. . exporting table           BACK_BASE_DICTIONARY        221 rows exported
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
. . exporting table      BACK_BASE_DICTIONARY_BACK        133 rows exported
. . exporting table                BACK_BASE_LEVEL          9 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table      BACK_BASE_USER_BASIC_INFO      87678 rows exported
EXP-00091: Exporting questionable statistics.

解決EXP-00091的方法

SQL> select userenv('language') from dual;

USERENV('LANGUAGE')
----------------------------------------------------
AMERICAN_AMERICA.ZHS16GBK

SQL>
或者：
select * from nls_database_parameters t where t.parameter='NLS_CHARACTERSET'
or
select * from v$nls_parameters where parameter='NLS_CHARACTERSET';

根据上面查出的字符集来设置环境变量
WINNT> set NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
LINUX> export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK

ok就这么简单

ITPub博客

EXP备份数据库的时候报错EXP-00091：

最新文章