874823 wrote:What do you mean "i am not sure whether the tables has been ziped".
i am using below unix command to exporting table data to other sever . But my requirement is i need to convert dmp file to ".gz" file . is it possible to convert it during exporting .
My Command is given below :
expdp username/password tables=sample directory=test_direcotry dumpfile=sample.dmp.gz logfile=sample.log
but the file has been converted into ".gz" file but i am not sure whether the tables has been ziped or not.
please help me from this problem.
mknod pipe_exp pAre you sure that works ? Also, isn't there a mix of exp and expdp parameters ?
# Gzip in the background
nohup gzip < pipe_exp > sample.dmp.gz &
expdp username/password tables=sample \
full=y direct=y compress=n buffer=10485760 \
exp username/password tables=sample \ direct=y compress=n buffer=10485760 \ file=pipe_exp log=sample.log
I did not think though the utility as such was in the focus of the question.Yes, and my first (tendentious :) ) question was related to GZIPing "on the fly" using expdp, which does not work, as per MOS Doc.ID 463336.1 Is It Possible To Use DataPump Export (EXPDP) Directly With GZIP?