Getting “EXP-00091: Exporting questionable statistics.” error on Oracle export
Home > IT Answers > Oracle > Getting "EXP-00091: Exporting questionable st...
DeloeranGuy
55 pts.
0
Q:
Getting "EXP-00091: Exporting questionable statistics." error on Oracle export
Oracle error messages, Oracle 10.2.0.1.0
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: Oct 21 2009  7:25 PM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
Carlosdl
29820 pts.
0
A:
 RATE THIS ANSWER
+1
Click to Vote:
  •   1
  •  0
  • AddThis Social Bookmark Button
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 Answered: Oct 21 2009  8:40 PM GMT by Carlosdl   29820 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

DeloeranGuy   55 pts.  |   Oct 21 2009  9:39PM GMT

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.  |   Oct 21 2009  9:41PM GMT

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

 

Carlosdl   29820 pts.  |   Oct 21 2009  9:53PM GMT

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.

 

DeloeranGuy   55 pts.  |   Oct 21 2009  10:04PM GMT

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!

 
0