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?
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.
Doesn't that mean on import you will have NO stats, unless you recalc during the import?
According to the documentation
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.