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.
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.
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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ashilo,
Please do not just look up Oracle errors message from Google or the online docs and just post the text.
Please do not just look up Oracle errors message from Google or the online docs and just post the text.
ASKER
Tks slightwv.
I will try it. Let you know the result.
I will try it. Let you know the result.
ASKER
Here is what I got, any idea?
-bash-3.00$ export NLS_LANG=AMERICAN_AMERICA.
-bash-3.00$ exp file=opm.exp log=opm_exp.log tables=\(OPM_ACTIVITY,....
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:
-bash-3.00$ export NLS_LANG=AMERICAN_AMERICA.
-bash-3.00$ exp file=opm.exp log=opm_exp.log tables=\(OPM_ACTIVITY,....
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:
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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?
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?
Did you look up the text for the error?
If you are setting it properly then you must not have installed the necessary files.
If you are setting it properly then you must not have installed the necessary files.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Tks
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.