| 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) ???
Actually, you'd want to use "statistics=3Dsafe"
from metalink:
What is the new value SAFE of the STATISTICS parameter at IMPORT ? The =
4 possible values for this parameter are : -> ALWAYS : =
Always imports database optimizer statistics regardless of wether or not =
they are questionable. =20
-> NONE : Does not import or recalculate the database optimizer =
statistics. =20
-> SAFE : Imports database optimizer statistics back only if they =
are not questionable. If they are questionable, recalculates the =
optimizer statistics. =20
-> RECALCULATE : Does not import the database optimizer statistics. =
Instead, recalculates them on import. =20
Never heard of expdp or impdp; they're not in the $ORACLE_HOME/bin = directory.
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Pete Sharman
Sent: Monday, February 23, 2004 9:29 AM
To: oracle-l_at_freelists.org
Subject: RE: EXP-00091 when full database export (9.2.0.4) ???
On 9i? Do you know something the rest of use don't? :)
Pete
"Controlling developers is like herding cats."
Kevin Loney, Oracle DBA Handbook
"Oh no, it's not. It's much harder than that!"
Bruce Pihlamae, long-term Oracle DBA
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Mladen Gogala
Sent: Tuesday, February 24, 2004 4:06 AM
To: oracle-l_at_freelists.org
Subject: Re: EXP-00091 when full database export (9.2.0.4) ???
Export with "STATISTICS=3DNONE". You should also use expdp and impdp instead of exp/imp.
On 02/23/2004 11:38:58 AM, dba1 mcc wrote:
> 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:
>=20 >=20> EXP-00091: Exporting questionable statistics.
> . . 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
>=20 >=20
>=20
>=20> Do you Yahoo!?
> __________________________________
-- 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 ----------------------------------------------------------------- ---------------------------------------------------------------- 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 - 11:33:23 CST
 |
 |