-
ora 00091 questionable statistics export
hi,
I run an export and get the ora below. I check the error facility and they say I could amongst other things chande the NCHARSET of the client. How do I do that?
Thanks
00091, 00000, "Exporting questionable statistics."
*Cause: Export was able export statistics, but the statistics may not be usuable. 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, 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.
Life is what is happening today while you were planning tomorrow.
-
Are you using windows? Open the registry and go to HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE/HOME0 and look at NLS_LANG and make sure that it, "AMERICAN_AMERICA.WE8ISO8859P1", matches up with the result of
Code:
SQL > select *
from V$NLS_PARAMETERS
where parameter='NLS_CHARACTERSET';
PARAMETER VALUE
--------------------- -------------------
NLS_CHARACTERSET WE8ISO8859P1
-
if you don't want the message use statistics=NONE in the export
-
Originally Posted by dbtoo
if you don't want the message use statistics=NONE in the export
Doesn't that mean on import you will have NO stats, unless you recalc during the import?
"False data can act only as a distraction. Therefore. I shall refuse to perceive you." - Bomb #20
-
Life is what is happening today while you were planning tomorrow.
-
Originally Posted by tomcat
Doesn't that mean on import you will have NO stats, unless you recalc during the import?
According to the documentation
STATISTICS
Default: ESTIMATE
Specifies the type of database optimizer statistics to generate when the exported data is imported. Options are ESTIMATE, COMPUTE, and NONE. See the Import parameter STATISTICS and Importing Statistics.
In some cases, Export will place the precalculated statistics in the export file as well as the ANALYZE statements to regenerate the statistics.
However, the precalculated optimizer statistics will not be used at export time if a table has columns with system-generated names.
The precalculated optimizer statistics are flagged as questionable at export time if:
There are row errors while exporting
The client character set or NCHAR character set does not match the server character set or NCHAR character set
A QUERY clause is specified
Only certain partitions or subpartitions are exported
So, ndisang seemed to be chasing after an option that he may not have really wanted to do. Just an opinion. Exports are, in our case, only utilized to retrieve data that some user deleted or to refresh the data in very small databases (We never export/import our 'large' - relative term - databases.) ndisang will need to determine if having or generating the statistics for import is worth mucking around with character sets, etc. Just layin' out some options.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|