Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: EXP-00091 when full database export (9.2.0.4) ???

RE: EXP-00091 when full database export (9.2.0.4) ???

From: M Rafiq <rafiq9857_at_hotmail.com>
Date: Mon, 23 Feb 2004 11:57:39 -0500
Message-ID: <BAY99-F16RMclLn0JzD00085697@hotmail.com>


use statistics=none and try.

Regards
Rafiq'

From: "Bobak, Mark" <Mark.Bobak_at_il.proquest.com> Reply-To: oracle-l_at_freelists.org
To: <oracle-l_at_freelists.org>
Subject: RE: EXP-00091 when full database export (9.2.0.4) ??? Date: Mon, 23 Feb 2004 11:45:46 -0500

I've never run into this myself, but the "oerr" command is your friend:

oracle_at_dvlpq1 [/home/admin/oracle]oerr exp 91 00091, 00000, "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.

Some of those are easily correctable. Do you have your client character set defined correctly?
Are you exporting only specific partitions?

-Mark

Mark J. Bobak
Oracle DBA
ProQuest Company
Ann Arbor, MI
"Imagination was given to man to compensate him for what he is not, and a sense of humor was provided to console him for what he is." --Horace Walpole

-----Original Message-----
From: dba1 mcc [mailto:mccdba1_at_yahoo.com]=20 Sent: Monday, February 23, 2004 11:39 AM To: oracle-l_at_freelists.org
Subject: EXP-00091 when full database export (9.2.0.4) ???

We have ORACLE database run under SUN solaris 9 and ORACLE 9.2.0.4. While wd doing "FULL" database export, we got lots of error like:

. . exporting table            AQ$_INTERNET_AGENTS   =20
      0 rows exported
. . exporting table       AQ$_INTERNET_AGENT_PRIVS   =20
      0 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table                    DEF$_AQCALL   =20
      0 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table                   DEF$_AQERROR   =20
      0 rows exported
. . exporting table                  DEF$_CALLDEST   =20
      0 rows exported

EXP-00091: Exporting questionable statistics.

Can anyone tell me how to fix it?

Thanks.



Do you Yahoo!?
Yahoo! Mail SpamGuard - Read only the mail you want. http://antispam.yahoo.com/tools

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

_________________________________________________________________
Get a FREE online computer virus scan from McAfee when you click here. 
http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963

----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Received on Mon Feb 23 2004 - 10:54:35 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US