Getting “EXP-00091: Exporting questionable statistics.” error on Oracle export

55 pts.
Tags:
Oracle 10.2.0.1
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

Answer Wiki

Thanks. We'll let you know when a new response is added.

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.

Discuss This Question: 4  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • DeloeranGuy
    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!
    55 pointsBadges:
    report
  • DeloeranGuy
    Oh and pardon me, he's dumping the entire table with no WHERE clause...forgot to add that!
    55 pointsBadges:
    report
  • carlosdl
    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.
    69,920 pointsBadges:
    report
  • DeloeranGuy
    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!
    55 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following