EXP-00091: Exporting questionable statistics

EXP-00091: Exporting questionable statistics

Sometimes many EXP-00091: Exporting questionable statistics errors are reported when you use EXP tools to export or migrate data,
The processing method is as follows:

1. symptom
[Oracle @ node1] $ exp test/test file =/home/oracle/test20141104.dmp log =/home/oracle/test20141104.log buffer = 67108864
...... Ignore ......
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
.. Exporting table test 12 rows exported
EXP-00091: Exporting questionable statistics.
.. Exporting table users 129 rows exported
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
...... Ignore ......

2. Handling Method
Specifies the Linux system's NLS_LANG environment variable as the database Dataset
1) query the character set of the database (many methods use only one)
SQL> select userenv ('language') from dual;

USERENV ('language ')
----------------------------------------------------
AMERICAN_AMERICA.WE8ISO8859P1

2) set the Linux operating system's NLS_LANG environment variable
[Oracle @ node1] $ export NLS_LANG = AMERICAN_AMERICA.WE8ISO8859P1

To modify the environment variables of the Window system, follow these steps:
C: \> set NLS_LANG = AMERICAN_AMERICA.WE8ISO8859P1

3. OK. After processing is completed, this error will not be reported during the EXP export operation.

Oracle EXP export error EXP-00091 Analysis Solution

Explore Character Set problems in Oracle EXP/IMP Process

Oracle EXP imp backup and recovery of table space data

Oracle creates automatically executed EXP tasks

Oracle 11g export table reports EXP-00011: table does not exist

EXP/imp export import data reported error ORA-12154 failed to parse the specified connection identifier