Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: Importing when uncompressed is > 2GB

Re: Importing when uncompressed is > 2GB

From: Frank Seuberth <Frank.seuberth_at_odn.de>
Date: Wed, 20 Dec 2000 11:53:54 +0100
Message-ID: <3A408FC2.B71B6CA7@odn.de>

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/
Received on Wed Dec 20 2000 - 04:53:54 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US