Re: Will Oracle support file compression under NT3.51?
Date: 1995/07/25
Message-ID: <tcoxDC8w8v.K9u_at_netcom.com>#1/1
In article <3uj267$8ea_at_helios.vanderbilt.edu>,
Randy Fought <FOUGHTRL_at_CTRVAX.VANDERBILT.EDU> wrote:
> The new release of the Windows NT3.51 OS has added file compression
>as an optional feature. Will Oracle operate correctly using a disk or
>disks that use an operating system level file compression?
Yes, it does.
> Does Oracle support file compression on any other platforms?
Yes, provided that support is in the OS or is otherwise transparent to Oracle.
I use Oracle7 today on a system at home with OS-compressed disks, and Oracle has no idea.
WARNING: empty tablespaces compress very nicely, but full ones much less so -- i.e. while Oracle thinks the space is preallocated, in fact the OS may show the data file "growing" as the contents become less compressible. You could even run out of space and/or get weird OS errors.
Cheers.
-Tom
-- Thomas B. Cox tcox_at_netcom.com Author of _Oracle Workgroup Server Handbook_, ISBN 0-07-881186-4 ...be seeing you at IOUW '95!Received on Tue Jul 25 1995 - 00:00:00 CEST