Export error EXP-00091 with exp

Export error EXP-00091 with exp

Run the following command to export data:

Exp user/pwd @ db file =/home/a. dmp log =/home/a. log

Output The following information, which contains error prompts for some EXP-00091:

.. Exporting table T 0 rows exported
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.

However, the exported dump file can be used for import.

Look at the official introduction to EXP-00091:

EXP-00091: Exporting questionable statistics.
Cause: Export was able export statistics, but the statistics may not be usuable. the statistics are questionable because one or more of the following happened during export: a row error occurred, client character set or NCHARSET does not match with the server, a query clause was specified on export, only certain partitions or subpartitions were exported, or a fatal error occurred while processing a table.
Action: To export non-questionable statistics, change the client character set or NCHARSET to match the server, export with no query clause, export complete tables. if desired, import parameters can be supplied so that only non-questionable statistics will be imported, and all questionable statistics will be recalculated.

Generally, some statistics are unavailable because the client character set or NCHARSET parameters are inconsistent with those on the server. The solution is to export statistics that do not have any problems, or change the client character set or NCHARSET parameter.

Lab:
Solution 1:
Query server-side character sets:

SQL> select userenv ('language') from dual; USERENV ('language ')

-------------------------------------------------------

AMERICAN_AMERICA.AL32UTF8

Set the client character set:

[Oracle @ Node] ~> Export NLS_LANG = AMERICAN_AMERICA.AL32UTF8

Execute the Export command:

[Oracle @ Node] ~> Exp user/pwd @ db file =/home/a. dmp log =/home/a. log

.. Exporting table T 0 rows exported

No error is reported.

Solution 2:

Exp user/pwd @ db file =/home/a. dmp log =/home/a. log statistics = none

Set the statistics field to none.
Execute the Export command:

[Oracle @ Node] ~> Exp user/pwd @ db file =/home/a. dmp log =/home/a. log

.. Exporting table T 0 rows exported

No error is reported. However, this method is equivalent to not exporting statistical information that is incorrect due to Character Set inconsistency. This statistical information is not imported. If necessary, you can only collect statistical information again.

Therefore, for this exp report EXP-00091 errors, there can be the above two ways workaround, but the recommended certainly is solution 1, the export information is the most comprehensive.