| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: got EXP-00091 warning
My experience with this error:
<quote>
Add "statistics=none" during daily backup export command (if statistics
are really not need to be exported)
OR
ALWAYS : Always imports database optimizer statistics regardless of whether or not they are questionable.
NONE : Does not import or recalculate the database optimizer statistics.
SAFE : Imports database optimizer statistics back only if they are not questionable. If they are questionable, recalculates the optimizer statistics.
RECALCULATE : Does not import the database optimizer statistics. Instead, recalculates them on import.
When do we get these errors,
The precalculated optimizer statistics are flagged as questionable at
export time
if:
1)There are row errors while exporting
2)The client character set or NCHAR character set does not match
the server character set or NCHAR character set
3)A QUERY clause is specified
4)Only certain partitions or subpartitions are exported.
***
</quote>
HTH GovindanK
> Jin - Sounds good. Start with Google and with metalink.oracle.com. If as a
> result of your investigations you find that my simple-minded approach has
> overlooked a ghastly possibility, please post the results of your
> investigation. At some point I said this message was giving me too much
> information.
>
> Dennis Williams
> DBA, 80%OCP, 100% DBA
> Lifetouch, Inc.
> [EMAIL PROTECTED]
>
>
> -----Original Message-----
> Sent: Saturday, June 21, 2003 8:19 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Thanks Dennis,
> I wonder if I can find whether or not there is any problem in that schema,
> because that could be any of those "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".
>
> Jin
>
> Quoting DENNIS WILLIAMS <[EMAIL PROTECTED]>:
>
>> Jin
>> I cured this one with STATISTICS=NONE. Inelegant, but effective
>> nonetheless.
>>
>> Dennis Williams
>> DBA, 80%OCP, 100% DBA
>> Lifetouch, Inc.
>> [EMAIL PROTECTED]
>>
>>
>> -----Original Message-----
>> Sent: Friday, June 20, 2003 10:21 AM
>> To: Multiple recipients of list ORACLE-L
>>
>>
>> Greetings,
>>
>> When I export schema containing some tables, I got EXP-00091 warnings.
>> The
>> log
>> is saying:
>> "
>> ..
>> JServer Release 9.2.0.1.0 - Production
>> Export done in US7ASCII character set and AL16UTF16 NCHAR character set
>> server uses WE8ISO8859P1 character set (possible charset conversion)
>> . exporting pre-schema procedural objects and actions
>> . exporting foreign function library names for user XXX
>> . exporting PUBLIC type synonyms
>> . exporting private type synonyms
>> . exporting object type definitions for user XXX
>> About to export XXX's objects ...
>> . exporting database links
>> . exporting sequence numbers
>> . exporting cluster definitions
>> . about to export XXX's tables via Conventional Path ...
>> . . exporting table CHEMISTRY 0 rows
> exported
>> EXP-00091: Exporting questionable statistics.
>> . . exporting table CHEMISTRY_ALIAS 0 rows
> exported
>> EXP-00091: Exporting questionable statistics.
>> . . exporting table DESTINATION_PLATE_WELL 0 rows
> exported
>> EXP-00091: Exporting questionable statistics.
>> ...
>> "
>>
>> I check oracle document and it says:
>> "
>> EXP-00091 Exporting questionable statistics
>>
>> Cause: Export was able to export statistics, but the statistics may
> not
>> be
>> useable. 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, or
> 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.
>> "
>>
>> So I think the problem is chararter set not matching. So how can I
>> change
>> client
>> character set?
>>
>> Thanks,
>> Jin
>> --
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: GovindanK INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Sat Jun 21 2003 - 21:39:34 CDT
 |
 |