RE: Import thru pipe if .gz possible?
- From: <jim.silverman@xxxxxxxxxxx>
- To: <cemail_219@xxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 15 Mar 2007 11:40:14 -0400
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@xxxxxxxxxxx
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of J. Dex
Sent: Thursday, March 15, 2007 11:19 AM
To: oracle-l@xxxxxxxxxxxxx
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
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
