EXP-00091: Exporting questionable statistics troubleshooting

EXP-00091: Exporting questionable statistics troubleshooting

When using EXP tool to export backup or migrate data, sometimes a lot of "EXP-00091: Exporting questionable statistics" error will be reported, the specific phenomenon and solution please watch ......

1. symptom
[Oracle @ RH207 exp] $ exp test/test file = test. dmf log = test. log
...... Ignore ......
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
.. Exporting table SNP_TXT 6345 rows exported
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
.. Exporting table SNP_TXT_CROSSR 1019 rows exported
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
EXP-00008: ORACLE error 1013 encountered
ORA-01013: user requested cancel of current operation
EXP-00056: ORACLE error 1403 encountered
...... 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 @ RH207 exp] $ 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.