Not just for transport between OS'es, the "dp" utilities are
exp/imp on steroids and are supposed to be much faster then the
"classics". I did expdp/impdp but I was unable to notice any drastic
difference, despite the fact that the schema I was exporting contained
both EMP and DEPT, 18 rows taken together. Unfortunately, my 10g installation
is intended strictly for testing, so I have to find several gigs of data
to exp/imp it. One thing is that the directory to which you are
exporting from must now be create using "create directory" command
in sqlplus. I have no idea how would that work in a real situation.
On 02/23/2004 01:35:12 PM, Ron Rogers wrote:
> 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
> -----------------------------------------------------------------
>
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:47:29 CST
