A EXP-00091 error occurred while Exp was exported:
. . Exporting Table FRIEND
..............
142480 rows Exported
EXP-00091: Exporting questionable statistics.
View the Oracle error message solution description for EXP-00091:
[ORACLE@MWSG1: ~] $oerr Exp 00091
00091, 00000, "exporting questionable statistics."
*cause:export is able Export statistics, but the statistics may
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 is 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 non-questionable statistics would be imported,
And all questionable statistics would be recalculated.
In the process of doing exp we may often encounter exp-00091:exporting questionable statistics. Such exp information, in fact, is the EXP error message, The reason for this is that the Nls_lang in the environment variable of our EXP tool is inconsistent with the nls_characterset in db.
⑴ us to view the value of Nls_characterset in db (Provide two methods): View plain Copy to clipboard print? Sys@ccdb>Select* fromNls_database_parameters TwhereT.parameter= ' Nls_characterset '; PARAMETER VALUE----------------------------------------nls_characterset Al32utf8 or Person sys@ccdb>Select* fromV$nls_parameterswhereParameter= ' Nls_characterset '; PARAMETER VALUE----------------------------------------nls_characterset Al32utf8 sys@c Cdb> SELECT * from Nls_database_parameters t where t.parameter= ' nls_characterset '; PARAMETER VALUE----------------------------------------nls_characterset Al32utf8 or Sys@ccdb> ; SELECT * from v$nls_parameters where parameter= ' nls_characterset '; PARAMETER VALUE----------------------------------------nls_characterset Al32utf8
⑵ View the Nls_lang in the environment variable:
[ORACLE@MWSG1: ~] $echo $NLS _lang
American_america. zhs16cgb231280--sure enough to be different from the Nls_characterset=al32utf8 in db.
⑶ sets the environment variable for exp according to the Nls_characterset (Al32utf8) identified by ⑴:
Winnt> set Nls_lang=american_america. Al32utf8
[ORACLE@MWSG1: ~] $export Nls_lang=american_america. Al32utf8
[ORACLE@MWSG1: ~] $echo $NLS _lang
American_america. Al32utf8-The setting is the same as Nls_characterset=al32utf8 in db.
⑷ again exp Export data to see if there are any EXP-00091 errors in the log.
. . Exporting Table FRIEND
...........................................................................
..............................................
1216253 rows Exported
. . Exporting Table Friend_grp
128 Rows Exported
Export terminated successfully without warnings. -Successfully exported without warning.
The EXP-00091 problem was solved.