RE: gunzip while doing export

2003-10-07 Thread Rothouse, Michael
# 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:

Re: gunzip while doing export

2003-10-07 Thread Mladen Gogala
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

RE: gunzip while doing export

2003-10-07 Thread Ofer Harel
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 ##

RE: gunzip while doing export

2003-10-07 Thread Norris, Gregory T [ITS]
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