RE: Import thru pipe if .gz possible?

From: Kerber, Andrew W. <Andrew.Kerber_at_umb.com>
Date: Thu, 15 Mar 2007 11:13:49 -0500
Message-ID: <D40740337A3B524FA81DB598D2D7EBB306F0EDE2@x6009a.umb.corp.umb.com>

Here is one I wrote a while back (mostly copied from elsewhere on the web):

$ cat pipe_imp.ksh
export USERNAME=axxxxxxxx
export PASSWORD=xxxxxxxxx
rm $USERNAME.pipe
/usr/sbin/mknod $USERNAME.pipe p
gunzip -c > $USERNAME.pipe < mydb_fullexport.20070*.exp.gz & imp $USERNAME/$PASSWORD ignore=y full=y commit=y buffer=8192000 log=imp.log file=$USERNAME.pipe

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of J. Dex Sent: Thursday, March 15, 2007 10:19 AM
To: oracle-l_at_freelists.org
Subject: Import thru pipe if .gz possible?

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.

Find a local pizza place, movie theater, and more....then map the best route!
http://maps.live.com/?icid=hmtag1&FORM=MGAC01

--

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

NOTICE: This electronic mail message and any attached files are confidential. The information is exclusively for the use of the individual or entity intended as the recipient. If you are not the intended recipient, any use, copying, printing, reviewing, retention, disclosure, distribution or forwarding of the message or any attached file is not authorized and is strictly prohibited. If you have received this electronic mail message in error, please advise the sender by reply electronic mail immediately and permanently delete the original transmission, any attachments and any copies of this message from your computer system. Thank you.

--

http://www.freelists.org/webpage/oracle-l Received on Thu Mar 15 2007 - 11:13:49 CDT