1.问题现象
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
. . exporting table SNP_TXT 6345 rows exported
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
. . exporting table SNP_TXT_CROSSR 1019 rows exported
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics
2.处理方法
指定Linux系统的NLS_LANG环境变量为数据库的数据集
1）查询数据库的字符集（方法很多只用一种）
SQL> select userenv('language') from dual;
USERENV('LANGUAGE')
----------------------------------------------------
AMERICAN_AMERICA.WE8ISO8859P1
2）设置Linux操作系统的NLS_LANG环境变量
[oracle@RH207 exp]$export NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1
Window系统的环境变量的修改方法是：
C:\>set NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P
这时有的问题可以解决，但有的却会报错如下：
./create120.8.sh: line 23: export: `CHINESE_CHINA.AL32UTF8': not a valid identifier
./create120.8.sh: line 24: export: `022': not a valid identifier
SQL*Plus: Release 11.2.0.1.0 Production on Mon Jun 1 15:02:42 2015
Copyright (c) 1982, 2009, Oracle. All rights reserved.
ERROR:
ORA-12705: Cannot access NLS data files or invalid environment specified
Enter user-name: SP2-0306: Invalid option.
Usage: CONN[ECT] [{logon|/|proxy} [AS {SYSDBA|SYSOPER|SYSASM}] [edition=value]]
where
SP2-0306: Invalid option.
Usage: CONN[ECT] [{logon|/|proxy} [AS {SYSDBA|SYSOPER|SYSASM}] [edition=value]]
where
SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
发现问题：Cannot access NLS data files or invalid environment specified
发现还是字符集的问题。
查看cat /etc/sysconfig/i18n，显示字符集为
LANG="en_US.UTF-8"
根据以下表格对应关系，export NLS_LANG ，再次执行exp命令时，无报错信息！
排错完成！
类似“SIMPLIFIED CHINESE_CHINA.AL32UTF8” 带空格需要加单引号''，其他的无空格可以不加。
LANG="en_US.UTF-8" export NLS_LANG="AMERICAN_AMERICN.AL32UTF8"
export NLS_LANG="CHINESE_CHINA.ZHS16GBK"
|
Language |
Locale ID |
NLS_LANG |
|
English (American) |
en_US.UTF-8 |
AMERICAN_AMERICA.AL32UTF8 |
|
English (American) |
en_US.ISO-8859-1 |
AMERICAN_AMERICA.WE8ISO8859P1 |
|
English (American) |
en_US.ISO-8859-15 |
AMERICAN_AMERICA.WE8ISO8859P15 |
|
English (Australian) |
en_AU.UTF-8 |
ENGLISH_AUSTRALIA.AL32UTF8 |
|
English (Australian) |
en_AU.ISO-8859-1 |
ENGLISH_AUSTRALIA.WE8ISO8859P1 |
|
English (Australian) |
en_AU.ISO-8859-15 |
ENGLISH_AUSTRALIA.WE8ISO8859P15 |
|
English (British) |
en_GB.UTF-8 |
ENGLISH_UNITED KINGDOM.AL32UTF8 |
|
English (British) |
en_GB.ISO-8859-1 |
ENGLISH_UNITED KINGDOM.WE8ISO8859P1 |
|
English (British) |
en_GB.ISO-8859-15 |
ENGLISH_UNITED KINGDOM.WE8ISO8859P15 |
|
English (Ireland) |
en_IE.UTF-8 |
ENGLISH_IRELAND.AL32UTF8 |
|
English (Ireland) |
en_IE.ISO-8859-1 |
ENGLISH_IRELAND.WE8ISO8859P1 |
|
English (Ireland) |
en_IE.ISO-8859-15 |
ENGLISH_IRELAND.WE8ISO8859P15 |
|
German |
de_DE.UTF-8 |
GERMAN_GERMANY.AL32UTF8 |
|
German |
de_DE.ISO-8859-1 |
GERMAN_GERMANY.WE8ISO8859P1 |
|
German |
de_DE.ISO-8859-15 |
GERMAN_GERMANY.WE8ISO8859P15 |
|
French |
fr_FR.UTF-8 |
FRENCH_FRANCE.AL32UTF8 |
|
French |
fr_FR.ISO-8859-1 |
FRENCH_FRANCE.WE8ISO8859P1 |
|
French |
fr_FR.ISO-8859-15 |
FRENCH_FRANCE.WE8ISO8859P15 |
|
Italian |
it_IT.UTF-8 |
ITALIAN_ITALY.AL32UTF8 |
|
Italian |
it_IT.ISO-8859-1 |
ITALIAN_ITALY.WE8ISO8859P1 |
|
Italian |
it_IT.ISO-8859-15 |
ITALIAN_ITALY.WE8ISO8859P15 |
|
Spanish |
es_ES.UTF-8 |
SPANISH_SPAIN.AL32UTF8 |
|
Spanish |
es_ES.ISO-8859-1 |
SPANISH_SPAIN.WE8ISO8859P1 |
|
Spanish |
es_ES.ISO-8859-15 |
SPANISH_SPAIN.WE8ISO8859P15 |
|
Spanish (Mexico) |
es_MX.UTF-8 |
MEXICAN SPANISH_MEXICO.AL32UTF8 |
|
Spanish (Mexico) |
es_MX.ISO-8859-1 |
MEXICAN SPANISH_MEXICO.WE8ISO8859P1 |
|
Spanish (Mexico) |
es_MX.ISO-8859-15 |
MEXICAN SPANISH_MEXICO.WE8ISO8859P15 |
|
Portuguese (Brazilian) |
pt_BR.UTF-8 |
BRAZILIAN PORTUGUESE_BRAZIL.AL32UTF8 |
|
Portuguese (Brazilian) |
pt_BR.ISO-8859-1 |
BRAZILIAN PORTUGUESE_BRAZIL.WE8ISO8859P1 |
|
Portuguese (Brazilian) |
pt_BR.ISO-8859-15 |
BRAZILIAN PORTUGUESE_BRAZIL.WE8ISO8859P15 |
|
Japanese |
ja_JP.EUC-JP |
JAPANESE_JAPAN.JA16EUC |
|
Japanese |
ja_JP.UTF-8 |
JAPANESE_JAPAN.AL32UTF8 |
|
Korean |
ko_KR.EUC-KR |
KOREAN_KOREA.KO16KSC5601 |
|
Korean |
ko_KR.UTF-8 |
KOREAN_KOREA.AL32UTF8 |
|
Chinese (simplified) |
zh_CN.GB18030 |
SIMPLIFIED CHINESE_CHINA.ZHS32GB18030 |
|
Chinese (simplified) |
zh_CN.UTF-8 |
SIMPLIFIED CHINESE_CHINA.AL32UTF8 |
|
Chinese (traditional) |
zh_TW.BIG5 |
TRADITIONAL CHINESE_TAIWAN.ZHT16BIG5 |
|
Chinese (traditional) |
zh_TW.UTF-8 |
TRADITIONAL CHINESE_TAIWAN |