Re: Newbie Backup Question - Compression

The advice may be something to do with a feature of some operating systems (I think AIX is the one that I heard this about) that can use sparse file techniques.

One unintended consequence of this was that on compression and decompression all the 'unused' space in the file was somehow thrown away, and the file that cam back was not the file that went out. This was certainly reported as a problem a few years ago - but I would be quite surprised if it hasn't been addressed.

--

Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk

Bob Fazio wrote in message ...
>
>If you are just talking about compressing the file to some sort of table or
>backup device. Go right ahead. It has nothing to do with the database.
>
>Ray Diaz <raydiaz1_at_excite.com> wrote in message
>news:IcSJ3.11031$t%3.942138_at_typ11.nn.bcandid.com...
>>
>> A client of mine has just purchased a program that uses Oracle 8.x and I
>am
>> using Veritas to do a cold backup. I was told by the application company
>> the we can NOT compress the Oracle database files.
>>
>> Is this true? I can't understand what compression would have to do with
>> files during a cold backup.
Received on Tue Oct 05 1999 - 03:15:01 CDT