| 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: EXP-00091 when full database export (9.2.0.4) ???
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
Can anyone tell me how to fix it?
Thanks.
-- 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 -----------------------------------------------------------------Received on Mon Feb 23 2004 - 10:42:41 CST
 |
 |