Solved

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

Posted on 2011-09-19
10
1,623 Views
Last Modified: 2012-06-21
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.
0
Comment
Question by:joaotelles
  • 5
  • 4
10 Comments
 
LVL 76

Accepted Solution

by:
slightwv (䄆 Netminder) earned 500 total points
ID: 36561301
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
 
LVL 15

Expert Comment

by:Aaron Shilo
ID: 36561303
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
 
LVL 76

Expert Comment

by:slightwv (䄆 Netminder)
ID: 36561326
ashilo,

Please do not just look up Oracle errors message from Google or the online docs and just post the text.
0
 

Author Comment

by:joaotelles
ID: 36561405
Tks slightwv.

I will try it. Let you know the result.
0
 

Author Comment

by:joaotelles
ID: 36562738
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
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
LVL 76

Assisted Solution

by:slightwv (䄆 Netminder)
slightwv (䄆 Netminder) earned 500 total points
ID: 36562759
Did you look up the text for ORA-12705?

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

Author Comment

by:joaotelles
ID: 36562867
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
 
LVL 76

Expert Comment

by:slightwv (䄆 Netminder)
ID: 36562891
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
 

Assisted Solution

by:joaotelles
joaotelles earned 0 total points
ID: 36562989
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
 

Author Closing Comment

by:joaotelles
ID: 36591838
Tks
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now