Home » RDBMS Server » Server Utilities » Error EXP-00091: Exporting questionable statistics. about character set
Error EXP-00091: Exporting questionable statistics. about character set [message #267867] Sat, 15 September 2007 20:51 Go to next message
luckyally
Messages: 16
Registered: August 2007
Location: Hyderabad
Junior Member

Hi all,
i have oracle 10.1.0 installed on windows xp .
While exporting i recieve this error.

EXP-00091: Exporting questionable statistics.

I presume this to be realted to statistics. i mean the statistics related to the table are old or may be not correct.

I came across a document on the internet to overcome this error
use the parameter statistics=none while exporting..

exp user1/user1 file=user111.dmp tables=emp statistics=none

after using this i dont get a warning . my question is it OK to do so? or is there any alternate to exp with out using statistics=none and not get a warning .. like do i have to generate statistics or something ??

Question 2 ) this is about the character set error given below
Export done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
server uses US7ASCII character set (possible charset conversion)

Since i am working on a standalone PC. how is it possible that there are two character sets defined. and how do i overcome this error .


The detailed log is mentioned below .. please help .. Shah

D:\good>exp user1/user1 file=user1.dmp tables=emp

Export: Release 10.1.0.2.0 - Production on Sun Sep 16 07:12:07 2007

Copyright (c) 1982, 2004, Oracle. All rights reserved.


Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Produc
tion
With the Partitioning, OLAP and Data Mining options
Export done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
server uses US7ASCII character set (possible charset conversion)

About to export specified tables via Conventional Path ...
. . exporting table EMP 8192 rows exported
EXP-00091: Exporting questionable statistics.
Export terminated successfully with warnings.


[mod-edit] colors and font removed.

[Updated on: Mon, 17 September 2007 08:28] by Moderator

Report message to a moderator

Re: Error EXP-00091: Exporting questionable statistics. about character set [message #267868 is a reply to message #267867] Sat, 15 September 2007 21:43 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

This was happened because the character in the registry does not match with the character set and in the database .
Before prompt export command you can use
Set NLS_LANG=.....
Re: Error EXP-00091: Exporting questionable statistics. about character set [message #267877 is a reply to message #267867] Sat, 15 September 2007 23:44 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,
Below are possible reason of EXP-00091 error.

exp-00091 exporting questionable statistics"

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

If a table is missing the columns specified in the QUERY clause, an error message will be produced, and no rows will be exported for the offending table.

Restrictions
The parameter QUERY cannot be specified for full, user, or tablespace mode exports.
The parameter QUERY must be applicable to all specified tables.
The parameter QUERY cannot be specified in a direct path export (DIRECT=y)
The parameter QUERY cannot be specified for tables with inner nested tables.
You cannot determine from the contents of the export file whether the data is the result of a QUERY export.


Suggestion:
When OS character set different that ORACLE character set then BEFORE export you should set NLS_LANG=.CHARACTERSET according Oracle Database Character set.
Example : Oracle 10gr2 on Linux version 4
OS NLS_LANG = US7ASCII
Oracle NLS_LANG = WE8IS0XXXXX

Just Before export set NLS_LANG like
$export NLS_LANG=.WE8ISOXXXXX
$export export script

Example on windows
First check "NLS_CHARACTERSET" of database through below query
SQL> select VALUE
2 from nls_database_parameters
3 where PARAMETER = 'NLS_CHARACTERSET';

VALUE
----------------------------------------
WE8MSWIN1252


On command prompt
c:\> set NLS_LANG=.WE8MSWIN1252



http://dbataj.blogspot.com/2007/01/exp-00091-exporting-questionable.html

Re: Error EXP-00091: Exporting questionable statistics. about character set [message #268033 is a reply to message #267877] Mon, 17 September 2007 04:36 Go to previous message
luckyally
Messages: 16
Registered: August 2007
Location: Hyderabad
Junior Member

Thanks everybody for reply ..

I try the suggestions and get back..

Shah
Previous Topic: Internal error: ulconnect: OCIInitialize [1804]
Next Topic: Exporting data error in oracle 9i
Goto Forum:
  


Current Time: Sun Dec 04 08:46:01 CST 2016

Total time taken to generate the page: 0.05410 seconds