Re: Upgrade 9.2 to 11.2 with minimal downtime
From: Chuck <chuckh1958_nospam_at_gmail.com>
Date: Fri, 03 Jun 2011 17:25:49 -0400
Message-ID: <isbjgt$ald$2_at_dont-email.me>
On 6/3/2011 3:21 PM, onedbguru wrote:
> On Jun 3, 11:27 am, Chuck <chuckh1958_nos..._at_gmail.com> wrote:
>
> How do you create mypipe? typical would be: "mknod mypipe p"
>
> you do know that you can use impdp with your 9i exp file, right? It
> does actually run faster than imp. If you have the space, bunzip it
> first.
Date: Fri, 03 Jun 2011 17:25:49 -0400
Message-ID: <isbjgt$ald$2_at_dont-email.me>
On 6/3/2011 3:21 PM, onedbguru wrote:
> On Jun 3, 11:27 am, Chuck <chuckh1958_nos..._at_gmail.com> wrote:
>> One more minor factor I forgot to mention :) .... >> >> I am also bunzipping the export file on the fly when importing it... >> >> bunzip2 < expdat.dmp.bz2 > mypipe & >> imp file=mypipe ... >> >> Don't ask. That's the way it's being delivered.
>
> How do you create mypipe? typical would be: "mknod mypipe p"
>
> you do know that you can use impdp with your 9i exp file, right? It
> does actually run faster than imp. If you have the space, bunzip it
> first.
Every time I try to load the 9i dump file with impdp I get
ORA-39143: dump file "/oramisc/export/TPMACPRD/test.dmp" may be an original export dump file
and it fails Received on Fri Jun 03 2011 - 16:25:49 CDT