Re: Importing when uncompressed is > 2GB

From: <roger_gorden_at_my-deja.com>
Date: Fri, 29 Dec 2000 16:24:59 GMT
Message-ID: <92idsh$hpt$1@nnrp1.deja.com>

Frank;

A brief correction to your tip, as it did not work. I tried this and it went smoothly. (From Oracle Metalink)

Reading a compressed export file

---

    % mknod /tmp/imp_pipe p                       # Make the pipe

    % uncompress < export.dmp.Z > /tmp/imp_pipe & # Background uncompress

    % imp file=/tmp/imp_pipe <other options> # Import from the pipe

Thanks for the help.

Roger

In article <91qp9g$9qu$1_at_nnrp1.deja.com>,   roger_gorden_at_my-deja.com wrote:
> Frank;
>
> Thank You. I'm going to try this as soon as I can.
> I appreciate the help.
>
> Roger
>
> In article <3A408FC2.B71B6CA7_at_odn.de>,
> Frank Seuberth <Frank.seuberth_at_odn.de> wrote:
> > Hi Roger,
> > try this :
> >
> > Create a pipe :
> >
> > mknod pipename.pipe
> >
> > uncomress comressedfile.Z > pipename.pipe
> >
> > Do the import imp userid=xxxxx/xxxx file=pipename.pipe
> >
> > Frank
> >
> > roger_gorden_at_my-deja.com schrieb:
> >
> > > Hi;
> > >
> > > I have been able to do logical backups that are larger than 2GB in
 size
> > > using the pipe and compress utility in UNIX. The compressed file
 is
> > > about 800 MB (uncompressed is much larger than 2 GB. Any Ideas if
 I
> > > just want to import/recover one table or a stored procedure?
> > >
> > > Thanks for the flame-free help.
> > >
> > > Roger
> > >
> > > Sent via Deja.com
> > > http://www.deja.com/
> >
> >
>
> Sent via Deja.com
> http://www.deja.com/
>

Sent via Deja.com
http://www.deja.com/ Received on Fri Dec 29 2000 - 10:24:59 CST