Re: Upgrade 9.2 to 11.2 with minimal downtime
From: joel garry <joel-garry_at_home.com>
Date: Fri, 3 Jun 2011 16:20:24 -0700 (PDT)
Message-ID: <c9b01dd2-2665-492b-b392-8e2a727b1d31_at_18g2000prd.googlegroups.com>
On Jun 3, 12:21 pm, onedbguru <onedbg..._at_yahoo.com> 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.
Date: Fri, 3 Jun 2011 16:20:24 -0700 (PDT)
Message-ID: <c9b01dd2-2665-492b-b392-8e2a727b1d31_at_18g2000prd.googlegroups.com>
On Jun 3, 12:21 pm, onedbguru <onedbg..._at_yahoo.com> 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.
Demo please? You can with the scripts, not with the dump. That's why
they've kept the original around.
http://download.oracle.com/docs/cd/E11882_01/server.112/e16536/dp_legacy.htm
http://download.oracle.com/docs/cd/B19306_01/server.102/b14215/dp_export.htm
No pipes with datapump.
jg
-- _at_home.com is bogus. http://www.signonsandiego.com/news/2011/jun/02/once-enemies-nokia-and-qualcomm-now-partners/Received on Fri Jun 03 2011 - 18:20:24 CDT