unix/linux上备份Oracle时EXP-00091的错误解决方法
unix/linux上备份数据时的错误解决方法
EXP-00091: Exporting questionable statistics.解决方法
今日EXP数据发现如下错误：
EXP-00091: Exporting questionable statistics.
. . exporting table TAXVOU3129 2904185 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.
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
. . exporting table TIPS_BUDGET_SUBJECT_INCOME 2297 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table TRBUDGETBILL3128 0 rows exported
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
. . exporting table TRDRAWBACKBILL3128 0 rows exported
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
. . exporting table TRECODEINFO104 849 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table TRECODEINFO9100 1 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table TRREMOVEBILL3128 0 rows exported
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
. . exporting table TRSHAREBILL3128 0 rows exported
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
. . exporting table TYPE_TABLE_RELATION 12 rows exported
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
. . exporting table UNTAX_BILLPRICE 0 rows exported
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
. . exporting table UNTAX_BILLPRINTERY 0 rows exported
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
. . exporting table UNTAX_CHARGEKIND 0 rows exported
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
. . exporting table UNTAX_ITEMSORT 0 rows exported
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
. . exporting table USERS 1 rows exported
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
. . exporting table USER_ROLE 28 rows exported
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
. . exporting table VIEW_LIST 0 rows exported
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
. . exporting table VIEW_MANAGER 0 rows exported
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
. exporting synonyms
. exporting views
. exporting stored procedures
. exporting operators
. exporting referential integrity constraints
. exporting triggers
. exporting indextypes
. exporting bitmap, functional and extensible indexes
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
. exporting posttables actions
. exporting materialized views
. exporting snapshot logs
. exporting job queues
. exporting refresh groups and children
. exporting dimensions
. exporting post-schema procedural objects and actions
. exporting statistics
Export terminated successfully with warnings.
解决方法：
select * from nls_database_parameters t where t.parameter=’NLS_CHARACTERSET’
or
select
* from v$nls_parameters where
parameter=’NLS_CHARACTERSET’;
查询值为：ZHS16GBK
然后vi
/home/oracle/.bash_profile
export
NLS_LANG=american_america.ZHS16GBK
source
/home/oracle/.bash_profile
windows下：
set
NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
（定义系统环境变量可永久生效）
或注册表中设置环境变量
HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_OraDb10g_home1\NLS_LANG
修改NLS_LANG将其改为AMERICAN_AMERICA.ZHS16GBK
然后再进行EXP
.
. exporting table
TAXVOU3129 2913768 rows exported
.
. exporting table TIPS_BUDGET_SUBJECT_INCOME
2297 rows exported
.
. exporting table
TRBUDGETBILL3128 0 rows exported
.
. exporting table TRDRAWBACKBILL3128
0 rows exported
.
. exporting table
TRECODEINFO104 849 rows exported
.
. exporting table
TRECODEINFO9100 1 rows exported
.
. exporting table
TRREMOVEBILL3128 0 rows exported
.
. exporting table
TRSHAREBILL3128 0 rows exported
.
. exporting table TYPE_TABLE_RELATION
12 rows exported
.
. exporting table
UNTAX_BILLPRICE 0 rows exported
.
. exporting table UNTAX_BILLPRINTERY
0 rows exported
.
. exporting table
UNTAX_CHARGEKIND 0 rows exported
.
. exporting table
UNTAX_ITEMSORT 0 rows exported
.
. exporting table
USERS 1 rows
exported
.
. exporting table
USER_ROLE 28 rows exported
.
. exporting table
VIEW_LIST 0 rows exported
.
. exporting table
VIEW_MANAGER 0 rows exported
.
exporting synonyms
.
exporting views
.
exporting stored procedures
.
exporting operators
.
exporting referential integrity constraints
.
exporting triggers
.
exporting indextypes
.
exporting bitmap, functional and extensible indexes
.
exporting posttables actions
.
exporting materialized views
.
exporting snapshot logs
.
exporting job queues
.
exporting refresh groups and children
.
exporting dimensions
.
exporting post-schema procedural objects and actions
.
exporting statistics
Export
terminated successfully without warnings.