オラクル

EXP-00091：疑わしい統計のエクスポート。問題は解決しました！



Exp 00091 Exporting Questionable Statistics



2019 Unicorn Enterprise Heavy Gold Recruitment Python Engineer Standard >>> hot3.png

expを実行する過程でexp、impを使用する必要があるDBAまたは通常のユーザーの場合、EXP-00091疑わしい統計のエクスポートに遭遇することがよくあります。このようなEXP情報は、実際にはexpのエラーメッセージであり、その理由です。これは、expツールが配置されている環境変数のNLS_LANGがDBのNLS_CHARACTERSETと矛盾しているためです。



問題：

lpding-> exp scott/scott file=/oracle/exp/scott_emp.dmp log scott_emp.log tables=emp Export: Release 10.2.0.1.0 - Production on Tue Jun 29 15:07:38 2010 Copyright (c) 1982, 2005, Oracle. All rights reserved. Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production With the Partitioning, OLAP and Data Mining options Export done in UTF8 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 EMP 14 rows exported EXP-00091: Exporting questionable statistics. EXP-00091: Exporting questionable statistics. Export terminated successfully with warnings.

解決する：



SQL> select * from v$nls_parameters where parameter='NLS_CHARACTERSET' PARAMETER VALUE ------------------------------- --------------------------------------------------------------------------------------------------- NLS_CHARACTERSET ZHS16GBK SQL> host $ export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK $ exp scott/scott file=/oracle/exp/scott_emp.dmp log scott_emp.log tables=emp Export: Release 10.2.0.1.0 - Production on Tue Jun 29 15:32:08 2010 Copyright (c) 1982, 2005, Oracle. All rights reserved. Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production With the Partitioning, OLAP and Data Mining options Export done in ZHS16GBK character set and AL16UTF16 NCHAR character set About to export specified tables via Conventional Path ... . . exporting table EMP 14 rows exported Export terminated successfully without warnings. lpding->


転載：https：//my.oschina.net/hycx227/blog/480113