EXP-00091: Exporting questionable statistics

最常见的 exp 报错，这个原因是因为exp工具所在的环境变量中的NLS_LANG与DB中的NLS_CHARACTERSET不一致。

有两种解决方法：

1.检查数据库里的变量设置值，然后在工具环境变量里同步

2.在exp语句中加入statistics=none，但这个要根据自己是否需要统计信息而定。

 

检查数据库相关参数：

SQL> select * from v$nls_parameters where parameter='NLS_CHARACTERSET';

PARAMETER                                                                                            VALUE
------------------------------- -------------------------------------------------------------------------------
NLS_CHARACTERSET                                                                             ZHS16GBK

 

export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
然后再 exp.......

 

PS:

select parameter,value from nls_database_parameters;

 

 

 

PARAMETER                      VALUE
------------------------------ ---------------------------------------------------------------------------------------------------

NLS_LANGUAGE                   AMERICAN
NLS_TERRITORY                  AMERICA
NLS_CURRENCY                   $
NLS_ISO_CURRENCY               AMERICA
NLS_NUMERIC_CHARACTERS         .,
NLS_CHARACTERSET               AL32UTF8
NLS_CALENDAR                   GREGORIAN
NLS_DATE_FORMAT                DD-MON-RR
NLS_DATE_LANGUAGE              AMERICAN
NLS_SORT                       BINARY
NLS_TIME_FORMAT                HH.MI.SSXFF AM

NLS_TIMESTAMP_FORMAT           DD-MON-RR HH.MI.SSXFF AM
NLS_TIME_TZ_FORMAT             HH.MI.SSXFF AM TZR
NLS_TIMESTAMP_TZ_FORMAT        DD-MON-RR HH.MI.SSXFF AM TZR
NLS_DUAL_CURRENCY              $
NLS_COMP                       BINARY
NLS_LENGTH_SEMANTICS           BYTE
NLS_NCHAR_CONV_EXCP            FALSE
NLS_NCHAR_CHARACTERSET         AL16UTF16
NLS_RDBMS_VERSION              10.2.0.3.0