ITPub博客

首页 > Linux操作系统 > Linux操作系统 > EXP-00091: Exporting questionable statistics.

EXP-00091: Exporting questionable statistics.

原创 Linux操作系统 作者:-卡卡- 时间:2012-06-12 09:10:32 0 删除 编辑
今天用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/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2012-03-31

  • 博文量
    29
  • 访问量
    235855