RE: Data Pump and compress on the fly in Unix

  • From: fairlie rego <fairlie_r@xxxxxxxxx>
  • To: Leng.Kaing@xxxxxxxxxxx
  • Date: Wed, 10 Jan 2007 20:53:26 -0800 (PST)

Yeah and I also know of Oracle bugs which have been closed on the premise that 
disk space is cheap (where the workaround has meant additional disk space)

Leng Kaing <Leng.Kaing@xxxxxxxxxxx> wrote:
        st1\:*{behavior:url(#default#ieooui) }                My biggest 
disappointment with data pump at the moment is this fact - I can't continue to 
compress on the fly like I did with exports. I have an issue at the moment 
where floating data types are not support with export and have been told to use 
data pump. 
  For all the goodies that data pump is supposed to provide, you would think 
that it compresses more than the metadata. What about the rest of the data? I 
know disks are supposed to be cheap now but we all know how hard it is to get 
the company to pay for it. I would gladly convert to data pump if I can 
compress on the fly too. 
  Imagine presenting this to management: I need more disk to use data pump 
because it does not allow compress on the fly. And the reason I need to use 
data pump is because exp doesn't support a data type that is currently used by 
Oracle BAM.
  Management will say: they are both Oracle's product - BAM either has to 
change data type, or data pump has to compress and use the same space as before.
  I?ve logged an SR with Oracle and the analyst tells me that the unix 
?compress? command is not recommended in the first place. I should not be 
compressing export dumps either from exp or data pump. What the heck is going 
on here? I?ve never heard of this one before. I?ve been using it for years 
without problems. There are even metalink notes to guide us through that. I?ve 
said the very same thing to him and he?s now working on his response.
  Leng Kaing
  Senior Oracle DBA
  Hansen Technologies; 2 Frederick St; Doncaster 3108
  Ph: +61-3-9840-3832
  -----Original Message-----
From: Mladen Gogala [mailto:mgogala@xxxxxxxxxxx] 
Sent: Thursday, 11 January 2007 3:17 PM
To: pythianbrinsmead@xxxxxxxxx
Cc: Leng Kaing; oracle-l@xxxxxxxxxxxxx
Subject: Re: Data Pump and compress on the fly in Unix
  On 01/10/2007 10:35:22 PM, Mark Brinsmead wrote:
  > Here's a silly suggestion...
  > Have you tried a compressed filesystem? 
  To my knowledge, that option is only available on an operating system 
  whose name should not be spoken aloud among the civilized oraclites. Can
  that be done on a system which cannot run SQL Server database?
  Mladen Gogala

          Fairlie Rego
Senior Oracle Consultant
  M: +61 402 792 405

Have a burning question? Go to Yahoo! Answers and get answers from real people 
who know.

Other related posts: