EXP-00091: Exporting questionable statistics.

Export: Release 12.2.0.1.0 - Production on Wed Feb 19 17:51:26 2020

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


Connected to: Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
Export done in US7ASCII character set and AL16UTF16 NCHAR character set
server uses ZHS16GBK character set (possible charset conversion)

About to export specified users ...
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user PERCIRCLE_NEW 
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user PERCIRCLE_NEW 
About to export CIRCLE_NEW's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
. about to export CIRCLE_NEW's tables via Conventional Path ...
. . exporting table                      BASE_AREA          0 rows exported
. . exporting table           BASE_DATA_DICTIONARY       3268 rows exported
. . exporting table                  BASE_SEQUENCE         14 rows exported
EXP-00091: Exporting questionable statistics.

……

. exporting statistics
Export terminated successfully with warnings.
 

当客户端 nls_lang 参数和字符集与数据库的不匹配时,出现 EXP-00091错误。

sql> select * from nls_database_parameters where parameter='NLS_CHARACTERSET';

NLS_CHARACTERSET	ZHS16GBK
# CentOS 7 添加环境变量
$ export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK

运行导出使命即可:

exp circle_new/circle_n@zx.orac.prod:1521/ZX owner=circle_new compress=n file=percircle_db_20200219.dmp