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.

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

Quote:

---

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?

thanks y'alll

Quote:

---

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. ;)