Oracle exp 报EXP-00091: Exporting questionable statistics

今日导出scott用户下的表报错 EXP-00091: Exporting questionable statistics.

[oracle@peter bak]$ exp scott/tiger file=expdat_scott20110313.dmp  grants=y log=explog_20110313.log owner=scott

Export: Release 10.2.0.1.0 - Production on Wed May 18 18:02:02 2011

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
Export done in US7ASCII character set and AL16UTF16 NCHAR character set
server uses ZHS16GBK character set (possible charset conversion)
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user SCOTT
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user SCOTT
About to export SCOTT's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
. about to export SCOTT's tables via Conventional Path ...
. . exporting table                          BONUS          0 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table                           DEPT          4 rows exported
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
. . exporting table                            EMP         14 rows exported
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
. . exporting table                       SALGRADE          5 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table                          TEST1          1 rows exported
. . exporting table                         TEST11          1 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 with warnings.
[oracle@peter bak]$

 

经过百度一番得知原因：exp工具所在的环境变量中的NLS_LANG与DB中的NLS_CHARACTERSET不一致

 

DB中的NLS_CHARACTERSET为：

SQL> select * from nls_database_parameters t where t.parameter='NLS_CHARACTERSET';

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

 

或者

 

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

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

 

在exp工具环境下执行

WINNT> set NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
LINUX> export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK 

或者

[oracle@peter ~]$ vi .bash_profile   

其中添加

export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK

然后

[oracle@peter ~]$ source .bash_profile

 

 

 再导出一次

[oracle@peter bak]$ exp scott/tiger file=expdat_scott20110313.dmp  grants=y log=explog_20110313.log owner=scott

Export: Release 10.2.0.1.0 - Production on Wed May 18 18:17:05 2011

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
Export done in ZHS16GBK character set and AL16UTF16 NCHAR character set
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user SCOTT
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user SCOTT
About to export SCOTT's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
. about to export SCOTT's tables via Conventional Path ...
. . exporting table                          BONUS          0 rows exported
. . exporting table                           DEPT          4 rows exported
. . exporting table                            EMP         14 rows exported
. . exporting table                       SALGRADE          5 rows exported
. . exporting table                          TEST1          1 rows exported
. . exporting table                         TEST11          1 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.
[oracle@peter bak]$

问题解决，嘿嘿！O(∩_∩)O~