Re: Import thru pipe if .gz possible?

From: Radoulov, Dimitre <cichomitiko_at_gmail.com>
Date: Thu, 15 Mar 2007 17:20:28 +0100
Message-ID: <05fd01c7671d$da098d00$1803310a@ETP6320>

} I have got a file that is gzipped. Is it possible to do a database
import
} through a pipe from a .gz file? Does anybody have a script for doing
this?
} I am having a space issue and need to import the data but if I unzip the
} file first than I don't have enough disk space so I am wondering if there
is
} a way to keep it .gz but still import.

mknod exp_pipe p
gzip -d < dumpfile.gz > exp_pipe &
imp file=exp_pipe ...

Dimitre

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Mar 15 2007 - 11:20:28 CDT