Re: Upgrade 9.2 to 11.2 with minimal downtime

From: onedbguru <onedbguru_at_yahoo.com>
Date: Fri, 3 Jun 2011 12:21:23 -0700 (PDT)
Message-ID: <a3f19e31-1a1b-4c27-b9d8-8e13658bec04_at_dn9g2000vbb.googlegroups.com>

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. Received on Fri Jun 03 2011 - 14:21:23 CDT