# Create a Unix named pipe
mknod /tmp/exp_pipe p
# Start Compress through the pipe
compress /tmp/exp_pipe $dmpfile.Z
# Perform the export
exp / full=y file=/tmp/exp_pipe log=$logfile consistent=y
direct=y recordlength=65535
-Original Message-
Sent:
mknod expdat.dmp p
exp system/manager full=yes direct=yes log=/dev/console
dd if=expdat.dmp|bzip2|dd of=/dir/full_exp.dmp.bz2
Your sysadmin will love you, especially if your database has many
objects, shoewing up in the log file.
On Tue, 2003-10-07 at 10:44, Oracle DBA wrote:
Hi List,
How
Sami,
A short explanation for gzip in Unix environment (probably the same for
gunzip)
Export
--
set expfile= ...
set logfile= ...
set Pipefile=/tmp/exp_pipe1
mknod $Pipefile p
cat $Pipefile | gzip -c1 $expfile
exp user/password file=$Pipefile log=$logfile ...
\rm -f $Pipefile
##
How to compress(gunzip format) while doing export
itself? I know i have to use PIPE but somehow i
couldn't succeed.
(umask 077 ; mknod gz_pipe p)
gzip -c gz_pipe myfile.dmp.gz
exp [user] file=gz_pipe ...
--
My employers like me, but not enough to let me speak for them.
Greg Norris
Sprint