EXP-00091: Exporting questionable statistics.

EXP-00091: Exporting questionable statistics.

发表于 2012 年 01 月 16 日 由 惜分飞

链接：http://www.xifenfei.com/2402.html

标题：EXP-00091: Exporting questionable statistics.

作者：惜分飞©版权所有[文章允许转载,但必须以链接方式注明源地址,否则追究法律责任.]

一.出现EXP-00091错误

[oracle@localhost tmp]$ exp "'/ as sysdba'" tables=testxuchao.TAB_XN_PY_DICT \ > file = /tmp/xifenfei .dmp log= /tmp/xifenfei .log   Export: Release 9.2.0.4.0 - Production on Mon Jan 16 16:02:37 2012   Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.   Connected to: Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.4.0 - Production Export done in US7ASCII character set and AL16UTF16 NCHAR character set server uses ZHS16GBK character set (possible charset conversion)   About to export specified tables via Conventional Path ... Current user changed to TESTXUCHAO . . exporting table                 TAB_XN_PY_DICT      25433 rows exported EXP-00091: Exporting questionable statistics. EXP-00091: Exporting questionable statistics. Export terminated successfully with warnings.

当环境变量和数据库的不一致，在导出统计信息时候，会报EXP-00091错误。

二.查看NLS相关参数

[oracle@localhost tmp]$ echo $NLS_LANG AMERICAN   SQL>  col value for a30 SQL>  select parameter,value from nls_database_parameters     2  where parameter like '%CHARACTERSET%' ;   PARAMETER                      VALUE ------------------------------ ------------------------------ NLS_CHARACTERSET               AL32UTF8 NLS_NCHAR_CHARACTERSET         AL16UTF16

三.解决方法
1.设置NLS_LANG为NLS_CHARACTERSET

[oracle@localhost tmp] export NLS_LANG=AMERICAN_AMERICA.AL32UTF8 [oracle@localhost tmp]$ exp "'/ as sysdba'" tables=testxuchao.TAB_XN_PY_DICT \ > file = /tmp/xifenfei .dmp log= /tmp/xifenfei .log   Export: Release 9.2.0.4.0 - Production on Mon Jan 16 16:08:10 2012   Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.   Connected to: Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.4.0 - Production Export done in ZHS16GBK character set and AL16UTF16 NCHAR character set   About to export specified tables via Conventional Path ... Current user changed to TESTXUCHAO . . exporting table                 TAB_XN_PY_DICT      25433 rows exported Export terminated successfully without warnings.

2.使用statistics=none

[oracle@localhost tmp]$ exp "'/ as sysdba'" tables=testxuchao.TAB_XN_PY_DICT \

> file = /tmp/xifenfei .dmp log= /tmp/xifenfei .log  statistics=none

 

Export: Release 9.2.0.4.0 - Production on Mon Jan 16 16:08:53 2012

 

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

 

Connected to: Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production

With the Partitioning, OLAP and Oracle Data Mining options

JServer Release 9.2.0.4.0 - Production

Export done in US7ASCII character set and AL16UTF16 NCHAR character set

server uses ZHS16GBK character set (possible charset conversion)

 

About to export specified tables via Conventional Path ...

Current user changed to TESTXUCHAO

. . exporting table                 TAB_XN_PY_DICT      25433 rows exported

Export terminated successfully without warnings.