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: Ron Rogers <RROGERS_at_galottery.org>
Date: Mon, 23 Feb 2004 13:35:12 -0500
Message-Id: <s03a01b2.037@galottery.org>


EXPDP is the "DATA PUMP" option in the new 10g. I believe it is used to transport databases between OS'S.
Correct?
Ron

>>> Lisa.Koivu_at_Cendant-TRG.com 02/23/2004 12:57:31 PM >>> OK Mladen, what joke are you pulling with expdp and impdp? =20

-----Original Message-----
From: Mladen Gogala [mailto:mladen_at_wangtrading.com]=20 Sent: Monday, February 23, 2004 12:06 PM 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

> . . 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.
>=20
>=20

> Can anyone tell me how to fix it?
>=20

> Thanks.
>=20

> __________________________________
> 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
> -----------------------------------------------------------------
>=20

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 
-----------------------------------------------------------------

"The sender believes that this E-Mail and any attachments were free of
=
any virus, worm, Trojan horse, and/or malicious code when sent. This =
message and its attachments could have been infected during =
transmission.  By reading the message and opening any attachments, the
=
recipient accepts full responsibility for taking proactive and remedial
=
action about viruses and other defects. The sender's business entity is
=
not liable for any loss or damage arising in any way from this message
=
or its attachments."

----------------------------------------------------------------
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 - 12:32:41 CST

Original text of this message

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