EXP-00091: Exporting questionable statistics.

今天用exp导出目标数据库数据时提示：

EXP-00091: Exporting questionable statistics.

 

[oracle@KY22 admin]$ exp admin/admin@ns tables=z_ldry_yw file=/vm/nsdata/z_ldry_yw.dmp log=/vm/nsdata/z_ldry_yw.log triggers=n ;

Export: Release 10.2.0.1.0 - Production on \ufffd\ufffd\ufffd\u06b6\ufffd 6\ufffd\ufffd 12 08:45:16 2012

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

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Export done in ZHS16GBK character set and AL16UTF16 NCHAR character set
server uses AL32UTF8 character set (possible charset conversion)

About to export specified tables via Conventional Path ...
. . exporting table                      Z_LDRY_YW       9117 rows exported
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
Export terminated successfully with warnings.

 

解决办法：

1.查看目标数据库的字符集相关参数

SQL> select * from nls_database_parameters where parameter in ('NLS_LANGUAGE','NLS_TERRITORY','NLS_CHARACTERSET');
 
PARAMETER                      VALUE
------------------------------ --------------------------------------------------------------------------------
NLS_LANGUAGE                   AMERICAN
NLS_TERRITORY                  AMERICA
NLS_CHARACTERSET          AL32UTF8

 

2.在导出客户端界面上设置NLS_LANG环境变量

[oracle@KY22 admin]$ export NLS_LANG=AMERICAN_AMERICA.AL32UTF8
[oracle@KY22 admin]$ exp admin/admin@ns tables=z_ldry_yw file=/vm/nsdata/z_ldry_yw.dmp log=/vm/nsdata/z_ldry_yw.log triggers=n ;

Export: Release 10.2.0.1.0 - Production on Tue Jun 12 09:06:42 2012

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

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Export done in AL32UTF8 character set and AL16UTF16 NCHAR character set

About to export specified tables via Conventional Path ...
. . exporting table                      Z_LDRY_YW       9131 rows exported
Export terminated successfully without warnings.

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/26839123/viewspace-732519/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/26839123/viewspace-732519/