Oracle 10g - Error EXP-00091: Exporting questionable statistics.

Hi,

Do you know what this error means?

I think it is related to the character set,maybe setting NLS_LANG to WE8ISO8859P1 will solve it?

Something like export NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1.WE8ISO8859P1

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options
Export done in US7ASCII character set and AL16UTF16 NCHAR character set
server uses WE8ISO8859P1 character set (possible charset conversion)
 
About to export specified tables via Conventional Path ...
. . exporting table                   O_ACTY    1843826 rows exported
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
joaotellesAsked:
Who is Participating?
 
slightwv (䄆 Netminder)Connect With a Mentor Commented:
It might be because of the character set conversion.  It might also be because of old statistics.

>>maybe setting NLS_LANG to WE8ISO8859P1 will solve it?

Try it and see.
0
 
Aaron ShiloChief Database ArchitectCommented:
EXP-00091:
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.
0
 
slightwv (䄆 Netminder) Commented:
ashilo,

Please do not just look up Oracle errors message from Google or the online docs and just post the text.
0
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
joaotellesAuthor Commented:
Tks slightwv.

I will try it. Let you know the result.
0
 
joaotellesAuthor Commented:
Here is what I got, any idea?

-bash-3.00$ export NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1.WE8ISO8859P1

-bash-3.00$  exp file=opm.exp log=opm_exp.log tables=\(OPM_ACTIVITY,...., OPM_WPROFILE_DTVERSION_M\)
 
Export: Release 10.2.0.4.0 - Production on Mon Sep 19 15:14:41 2011
 
Copyright (c) 1982, 2007, Oracle.  All rights reserved.
 
 
Username: dpow
Password:
 
EXP-00056: ORACLE error 12705 encountered
ORA-12705: Cannot access NLS data files or invalid environment specified
Username: dpownera
Password:
 
EXP-00056: ORACLE error 12705 encountered
ORA-12705: Cannot access NLS data files or invalid environment specified
Username:
0
 
slightwv (䄆 Netminder)Connect With a Mentor Commented:
Did you look up the text for ORA-12705?

I've not done a lot with NLS but try:
export NLS_LANG=WE8ISO8859P1
0
 
joaotellesAuthor Commented:
Same thing:

Export: Release 10.2.0.4.0 - Production on Mon Sep 19 15:31:17 2011
 
Copyright (c) 1982, 2007, Oracle.  All rights reserved.
 
 
Username: dpownera
Password:
 
EXP-00056: ORACLE error 12705 encountered
ORA-12705: Cannot access NLS data files or invalid environment specified
Username:

===============================

Here is what I read from the internet:
Cause: There are two possible causes: Either an attempt was made to issue an ALTER SESSION statement with an invalid NLS parameter or value; or the NLS_LANG environment variable contains an invalid language, territory, or character set.

===============================

Does this error invalid the export?
EXP-00091: Exporting questionable statistics.

Any other suggestion to overcome this error?
0
 
slightwv (䄆 Netminder) Commented:
Did you look up the text for the error?

If you are setting it properly then you must not have installed the necessary files.
0
 
joaotellesConnect With a Mentor Author Commented:
It worked now :)

NLS_LANG=.WE8ISO8859P1

Was missing a dot...

NLS_LANG consists of <language>_<territory>.<characterset>
You can specify the characterset only, provided you prefix it with a the dot character.
0
 
joaotellesAuthor Commented:
Tks
0
All Courses

From novice to tech pro — start learning today.