I'm new to Oracle 9i. When I use the exp command line tool I get numerous warnings about questionable statistics. What is the EXP-00091 error? The export doesn't fail, but I get many, many warnings. I never had this problem with previous versions of Oracle.
Thanks for your help.
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.
Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
Thanks for the reply. Any idea how I can determine what is causing the errors in this case? I don't think it can be the character set, I did the export at the server, so the client and server should be the same. There was no query clause specified, only owner=username. Having received those warnings on the export, can the dump file be trusted?
try to do this first:
in windows : SET NLS_LANG = <the charset of database server>
in unix : NLS_LANG = <the charset of the database server> ; export NLS_LANG;
then do the export again.
If that does not work out,
try to export with recalculated_statistics =NONE, then calculate the statisticus manually using "analyze ..."
Business Accounts
Answer for Membership
by: seazodiacPosted on 2003-11-04 at 15:15:14ID: 9682983
this is from oracle website:
EXP-00091 Exporting questionable statistics
Cause: Export was able to export statistics, but the statistics may not be useable. 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 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, or 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.