Home > IT Answers > Oracle > Getting “EXP-00091: Exporting questionable statistics.” error on Oracle export
DeloeranGuy
55 pts.
 Getting “EXP-00091: Exporting questionable statistics.” error on Oracle export
Oracle 10.2.0.1.0, Oracle error messages
My boss is getting an "EXP-00091: Exporting questionable statistics." error - actually, several identical messages per table - when using the EXP utility to dump several tables in an Oracle database.  I'm not familiar with this utility, so I'm researching the problem for my boss.  The information I have is he's using Oracle XE 10.2.0.1.0. 

Is this message common, and is it fatal?  The log file (below) says it's exported the correct number of records, so we need to know if we should be concerned.  Thanks!

*********** Partial LOG file below ***********

. . exporting table                       ABSENTEE        282 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. . . exporting table                  ABSENTEE_MEMO        248 rows exported EXP-00091: Exporting questionable statistics. EXP-00091: Exporting questionable statistics.

************** EOT ******************** 



Software/Hardware used:
Oracle 10.2.0.1.0
ASKED: October 21, 2009  7:25 PM
UPDATED: October 21, 2009  10:04 PM
RELATED QUESTIONS
Answer Wiki:
Is he exporting complete tables, or is he using a where clause when exporting ? If he's exporting complete tables, then the problem could be due to the fact that the character set of the client where the export utility is being run is different from the character set of the server. If that is the only error he's getting, then there is no reason to worry. To avoid the message you could run the export utility directly on the server, or you could change the client's characterset, or you could run the export utility with the 'STATISTICS=NONE' option.
Last Wiki Answer Submitted:  October 21, 2009  8:40 pm  by  carlosdl   63,535 pts.
All Answer Wiki Contributors:  carlosdl   63,535 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

Thanks for the reply. I certainly appreciate that questions often come with little information. At your response, my boss clarified that he’s running the extract on the same machine as the database/server (it all runs on a laptob, btw). He’s run this extract before a couple of times, and once got a clean run (i.e., no messages) and once with this same message.

If we can ignore this message, great. I’m just curious what “questionable statistics” means…thanks!

DeloeranGuy
 55 pts.
 

Oh and pardon me, he’s dumping the entire table with no WHERE clause…forgot to add that!

DeloeranGuy
 55 pts.
 

Oracle stores some statistics about objects (tables, indexes, etc…) which are used by the optimizer to choose the best execution plan for some operations. Those statistics include things like number of rows, number of distinct keys, etc…

By ‘questionable statistics’ it means that some statistics were included in the export operation, but they could be ‘inaccurate’, so it would be better to analyze the tables after importing the file into the database.

carlosdl
 63,535 pts.
 

You are right! I love this website!

Even though my boss ran the export on the same machine, he went back and did see a message about a character set not being the same, so the first guess was dead on.

My boss also believes he should analyze the tables after import, so that recommendation is dead on, too.

Thank you very much!

DeloeranGuy
 55 pts.