解决导出成功但报错EXP-00091: Exporting questionable statistics.
今天使用exp导出遇到错误EXP-00091: Exporting questionable statistics.
[oracle@test1 bin]$ exp scott/tiger file='/oradata/export.dmp' tables=test log='/oradata/export.log'
Export: Release 11.2.0.4.0 - Production on Mon Feb 22 14:22:06 2016
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 US7ASCII character set and AL16UTF16 NCHAR character set
server uses ZHS16GBK character set (possible charset conversion)
About to export specified tables via Conventional Path ...
. . exporting table TEST
. . exporting partition P1 1 rows exported
. . exporting partition P2 7 rows exported
. . exporting partition P3 6 rows exported
EXP-00091: Exporting questionable statistics.
Export terminated successfully with warnings.
查看了一下导出的文件，没问题。报错其实可以忽略，但是哪里报错呢
查一下好像是字符集的事情
sqlplus / as sysdba
SQL> select userenv('language') from dual;
USERENV('LANGUAGE')
USERENV('LANGUAGE')
----------------------------------------------------
修改字符集下面填你上面查到的字符集
[oracle@test1 bin]$ export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
[oracle@test1 bin]$ exp scott/tiger file='/oradata/export.dmp' tables=test log='/oradata/export.log'
Export: Release 11.2.0.4.0 - Production on Mon Feb 22 14:26:17 2016
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 ZHS16GBK character set and AL16UTF16 NCHAR character set
About to export specified tables via Conventional Path ...
. . exporting table TEST
. . exporting partition P1 1 rows exported
. . exporting partition P2 7 rows exported
. . exporting partition P3 6 rows exported
Export terminated successfully without warnings.
在导出有条件的记录时还是会出错，可能跟转义字符“ 、‘、（ 、> 这些有关系吧