RE: Import thru pipe if .gz possible?

From: <jim.silverman_at_thomson.com>
Date: Thu, 15 Mar 2007 11:40:14 -0400
Message-ID: <E2157B37A63D2E4B9B00575021FC84D69A3647@tshusmian2msg01.ERF.THOMSON.COM>

Yes, we do this all of the time. Here is a snippet of a CSH script to do so:

		set PIPE_FILE = "./imp_pipe.dmp"
		set DUMP_DIR  = "/directory_pathname"

	


########################################################################

#

		#   First create the named pipe, and start reading from
it in a
		#   background task.
	


########################################################################

#

		rm -f ${PIPE_FILE}
		mknod ${PIPE_FILE} p

		gunzip < ${DUMP_DIR}/export_file.dmp.gz > ${PIPE_FILE} &

	


########################################################################

#

		#   Now start the import.
	


########################################################################

#

		imp userid=...           \
		    file=${PIPE_FILE}    \
		    ...

HTH...

---

Jim Silverman
Senior Systems Database Administrator
Solucient, LLC - A Thomson Company
Telephone: 734-669-7641

FAX:            734-930-7611
E-Mail:         jim.silverman_at_thomson.com

-----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 11: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


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

Received on Thu Mar 15 2007 - 10:40:14 CDT