Topic: Backup & Recovery >> EXP-00091: Exporting questionable statistics. error
|
Disclaimer: The purpose of all dbapool forums including OCP and Other Oracle Certification forums is to help each other with specific issues but not to share dump and copyrighted exam content, materials or intellectual property.
You may review the entire Oracle Certification Program Candidate Agreement online Here.
|
|
|
|
| Title: EXP-00091: Exporting questionable statistics. error |
| SURESH |
Posted: Jan 10, 2007 10:29:13 AM |
Total Post: 10
Joined: Jan, 2007
|
while exporting database schema i got error
EXP-00091: Exporting questionable statistics. error
is it error or warring plz tell that
is their any problem with that
plz tell the solution to avoid that
Thanks
suresh kumar
mail_suresh_dba@yahoo.co.in |
|
|
 jagan |
| Posted: Jan 25, 2007 05:05:20 AM |  |
|
Total Post: 2
Joined: Dec, 2006
|
There are a few reasons for getting this message. One, probably the most common one, is a mismatch in NLS_LANG between the server and the client doing the export. Other reasons may be the existence of columns or indexes with system generated names (because they may be different if you import the export into another database). Yet other reasons are the use of a query cluase of limiting the export to a subset of partitions/subpartitions of a table.
It's not an error, it's a warning. If you don't need/want the statistics then Tom's advice of statistics=none gets rid of both, the statistics and the messages.
|
|
|
|
|
| sudheer pai |
| Posted: Feb 01, 2007 11:15:45 PM | |
|
Total Post: 34
Joined: Feb, 2007
|
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.
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
|
|
|
|
Forum Rules & Description
Who Can Read The Forum? Any registered user or guest
Who Can Post New Topics? Any registered user
Who Can Post Replies? Any registered user
|
| |
Get FREE Magazines
|
Top 10 Forum User
|
| Murtuja Khokhar | 857 |
| Mohammed Taj | 746 |
| positive fanatic | 483 |
| Jayanta Sur | 479 |
| Vigyan Kaushik | 386 |
| Vinoth Kumar | 357 |
| Gopu Gopi | 340 |
| Gitesh Trivedi | 322 |
| neeraj sharma | 258 |
| Ramesh Jois | 246 |
|
|
