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