exp00091oracle,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.