Re: Export for Upgrade

From: Chuck <chuckh_at_softhome.net>
Date: Wed, 9 Oct 2002 13:46:16 -0400
Message-ID: <ao1q1c$ibtab$1@ID-85580.news.dfncis.de>

"Jonathan Bliss" <bliss_jonathan_at_hotmail.com> wrote in message news:ae530df0.0210090133.38e9f799_at_posting.google.com...

>
> Duh *slaps heel of palm on forehead*
>
> Why can't I just import from the tape on the Unix box using the Unix
> 7.2 import utility to the NT box. If I need to run the 7.2 catexp.sql
> I can, if it does cause problems I can reset my database. Even if I
> don't know the commands (and I think even my Unix is up to this) all
> the basics are embedded in the current crontab and export parfile
> (daily exports to tape).
>
> Thanks to everyone who helped and sorry to waste your time.
>
> Jonathan

You could save yourself the time of creating a tape if you just pipe the output of exp into the input of imp.

mkfifo expdat.dmp
exp user/password file=expdat.dmp other_options.... & imp user/password_at_destination_db file=expdat.dmp other_options... Received on Wed Oct 09 2002 - 12:46:16 CDT