This content has been marked as final. Show 5 replies
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.
expdp is the oracle utility for exporting a database or selected portions of a database. (one could argue that it is not a "unix command", since it is an executable supplied by a third party). The output is a single file. In its simplest conceptual terms, that file contains a bunch of CREATE and INSERT statements. But it is a single file. When you zip it, you are zipping the file. The zip utility itself doesn't know or care about "tables" or anything else that may or may not be in the file. It is simply applying a mathematical algorithm byte by byte.
please help me from this problem.
Actually I have not used the export or datapump utility for the last 2 years and obviously forgotten some of its command line stuff. I did not think though the utility as such was in the focus of the question. So anyway, I took the chance to refresh my memory and can confirm that the below works for the export utility. Unfortunately not with datapump though.
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?
Edited by: Paul M. on Feb 14, 2013 12:04 PM
Of course we can use COMPRESSION option on 11g.