EXP-00091 Exporting questionable statistics

EXP-00091 Exporting questionable statistics may be frequently encountered in our EXP process for Oracle. in fact, it is the exp error message, which is generated because the environment variable where our exp tool is located is inconsistent with the NLS_CHARCATERSET in nls lang. But it should be noted that the EXP-00091 error has no impact on the generated dump file, the generated dump file can also be normal imp.

Next we will solve this problem so that it will not appear again:

 

1. view the value of NLS_CHARACTERSET in DB (two methods are provided ):

Query the value of NLS_CHARACTERSET:
Select * from nls_database_parameters t where t. parameter = 'nls _ CHARACTERSET'
Or
Select * from v $ nls_parameters where parameter = 'nls _ CHARACTERSET ';
SQL> select * from v $ nls_parameters where parameter = 'nls _ CHARACTERSET ';

PARAMETER VALUE
---------------------------------------------------------------------
NLS_CHARACTERSET ZHT16BIG5

 

2. Set the environment variable of exp according to the NLS_CHARACTERSET (ZHT16BIG5) found in Step 1:

WINNT> set NLS_LANG = AMERICAN_AMERICA.ZHT16BIG5

After setting, check whether the values of NLS_LANG are consistent in the environment variable. If the values are inconsistent, modify them in the environment variable.
LINUX> export NLS_LANG = AMERICAN_AMERICA.ZHT16BIG5

 

Attached to the exp-00091 of oracle error message solution description:

Error exp 91
00091,000 00, "Exporting questionable statistics ."
// * Cause: Export was able export statistics, but the statistics may not be
// Usuable. The statistics are questionable because one or more
// 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.