Re: on the fly zip compression

From: Mark Bole <makbo_at_pacbell.net>
Date: Thu, 17 Mar 2005 01:28:15 GMT
Message-ID: <P25_d.11241$C47.5094@newssvr14.news.prodigy.com>

NetComrade wrote:

> You can also compress tables to a certain degree in 9i, and to a
> larger degree in 10g. I believe you need enterprise license for that.
> 
> -A
> 
> 

>>Hi,
>>
>>I want to perform on the fly zip compression / decompression on
>>documents added and read from my oracle 9i database. I remember once
>>readiing an article about how this can be performed with a trigger and
>>stored procedures. But I have forgotten where I read this.
>>
>>Does anyone know how I can do this?
>>

See the UTL_COMPRESS package with 10g for general Lempel-Ziv compression capability. With 9i, there is key value compression (for example, with an index) and also data segment compression, although I have not tried the latter with LOB values.

-Mark Bole Received on Wed Mar 16 2005 - 19:28:15 CST