Re: Compressing Datafiles

We use gzip to compress/backup our datafiles every day. (They restore Ok too). Compression ratio is good typically between 40-60% - I think oracle datafiles generally have a fair bit of 'hot air' in them so compress quite nicely.

Mind you if your running that full - I would have serious words with someone about some more disk drives !

Incidently - interesting to hear the chap who said that Oracle informed them that compression was not a good idea as it was an oracle backup/recovery guy who told us it was a good one ?!!

<flowerss_at_my-deja.com> wrote in message news:8cvlpc$u8$1_at_nnrp1.deja.com...
> I'm trying to think outside of the box. We have a situation were the
> Server is just about 100% full on all file systems. It takes 91 hours
> for a Cold Backup, because a 10 Base Card was ordered instead of a 100
> Base Card. Funding has held up the order of the 100 Base Card. So
> until it's backed up, I can't remove any datafiles of the databases
> that are no longer being used.
>
> Temporarily, can a Datafile be Compressed? Has anyone tried it?
>
> Thanks,
> Selena
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Wed Apr 19 2000 - 00:00:00 CDT