Re: Data Pump and compress on the fly in Unix

Here's a silly suggestion...

Have you tried a compressed filesystem? It's been some time since I used one myself (probably for exports or maybe archive logging with 9i and AIX4) and I quickly abandoned the technique because I found it to be incredibly slow. But it will probably work with expdp, providing the compressed filesystem still permits random I/O.

Of course, feasibility and performance of this option will probably vary greatly by platform...

Another alternative that might work -- at least for some platforms -- is the good ol' cheap-and-stinking-huge disk drive. You didn't say how big your database is, but with 750GB SATA disks costing a few hundred dollars and 1TB disks just around the corner, there should be ways you can find the space you need without spending a huge amount of money. Chances are, this will outperform most techniques involving (software) compression.

On 1/8/07, Leng Kaing <Leng.Kaing_at_hsntech.com> wrote:
>
> Hi all,
>
>
>
> I think the question has been asked before but I'm hoping that 10.2.0.3has changed things – can we do a compress on the fly with expdb now? Ie.
> using mknod. Has anyone managed to get this to work?
>
>
>
> Ta,
>
>
>
> Leng.
>
>
>
> ------------------------------------------------------------------
>
> Leng Kaing
>
> Senior Oracle DBA
>
> Hansen Technologies; 2 Frederick St; Doncaster 3108
>
> Ph: +61-3-9840-3832
>
>
> Notice:
>
> This e-mail and any attachments are confidential and may contain legally
> privileged information and/or copyright material of Hansen Technologies
> Limited or third parties. Copying, distributing, disclosing, commercialising
> or otherwise acting in reliance on this e-mail and any attachments is
> strictly prohibited unless you are the addressee of this e-mail and have
> written permission to do so. If you have received this e-mail in error
> please delete this e-mail (including any copies and attachments) and contact
> Hansen Technologies Limited by return e-mail or by telephone on + 61 3 9840
> 3000. Any views expressed in this e-mail are those of the individual sender
> and may not necessarily reflect the views of or be a commitment by the
> organisation, except where the individual sender has the authority and
> expressly states them to be so.
>

-- 
Cheers,
-- Mark Brinsmead
   Senior DBA,
   The Pythian Group
   http://www.pythian.com/blogs

--
http://www.freelists.org/webpage/oracle-l