EXP-00091:Exporting questionable statistics

今天在oracle上做exp导出的时候报exp-00091;
查了下是服务端跟客户端的字符集不一致导致的

服务端字符集查询SQL:

select userenv('language') from dual;

执行过程如下:

E:\data>exp userid=mig/mig tables=T_CUSTOMER,T_PHONE,T_CUSTOMER_PHONE
 file=e:\data\pub.dump  log=e:\data\pub.log buffer=40960000 grants=n indexes=n t
riggers=n constraints=n

Export: Release 11.2.0.4.0 - Production on Tue Aug 29 15:50:24 2017

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.


Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit
Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Export done in UTF8 character set and UTF8 NCHAR character set
server uses AL32UTF8 character set (possible charset conversion)
Note: grants on tables/views/sequences/roles will not be exported
Note: indexes on tables will not be exported
Note: constraints on tables will not be exported

About to export specified tables via Conventional Path ...
. . exporting table                   T_CUSTOMER    1320672 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table                      T_PHONE    1869331 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table             T_CUSTOMER_PHONE    1869331 rows exported
EXP-00091: Exporting questionable statistics.
Export terminated successfully with warnings.

E:\data>echo $NLS_LANG
$NLS_LANG

E:\data>echo %NLS_LANG%
AMERICAN_AMERICA.UTF8

E:\data>set NLS_LANG=AMERICAN_AMERICA.AL32UTF8

E:\data>exp userid=mig/mig tables=T_CUSTOMER,T_PHONE,T_CUSTOMER_PHONE
 file=e:\data\pub.dump  log=e:\data\pub.log buffer=40960000 grants=n indexes=n t
riggers=n constraints=n

Export: Release 11.2.0.4.0 - Production on Tue Aug 29 15:55:25 2017

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.


Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit
Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Export done in AL32UTF8 character set and UTF8 NCHAR character set
Note: grants on tables/views/sequences/roles will not be exported
Note: indexes on tables will not be exported
Note: constraints on tables will not be exported

About to export specified tables via Conventional Path ...
. . exporting table                   T_CUSTOMER    1320672 rows exported
. . exporting table                      T_PHONE    1869331 rows exported
. . exporting table             T_CUSTOMER_PHONE    1869331 rows exported
Export terminated successfully without warnings.

E:\data>

最后提一下,utf8跟al32utf8字符集是不一样的,好吧,mark一下!

标签: oracle, exp, exp-00091, statistics, utf8, al32utf8

本文由 创作,采用 知识共享署名 3.0 中国大陆许可协议 进行许可。
可自由转载、引用,但需署名作者且注明文章出处。

相关文章

添加新评论

Title - Artist
0:00