Re: Function to compress text, not encrypt

  • From: "Juan Cachito Reyes Pacheco" <jreyes@xxxxxxxxxxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Fri, 12 Mar 2004 16:33:08 -0400

thanks
----- Original Message ----- 
From: "Justin Cave (DDBC)" <jcave@xxxxxxxxxxx>
To: <oracle-l@xxxxxxxxxxxxx>
Sent: Friday, March 12, 2004 4:37 PM
Subject: RE: Function to compress text, not encrypt



If you want to simulate table compression in the standard edition, you could
certainly write your own compression routine.  There are any number of
compression algorithms out there that are pretty well documented.

Of course, make sure that you compare the costs (development, maintenance,
and performance) of doing your own compression rather than spending money to
just buy an enterprise edition license.

Justin Cave
Distributed Database Consulting, Inc.
http://www.ddbcinc.com/askDDBC

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Juan Cachito Reyes Pacheco
Sent: Friday, March 12, 2004 1:25 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: Re: Function to compress text, not encrypt

Thanks Maryann
Number, and if possible strings.
The point is that standar edition don't have the compress features for
tables.

----- Original Message -----
From: "Maryann Atkinson" <maryann_30@xxxxxxxxx>
To: <oracle-l@xxxxxxxxxxxxx>
Sent: Friday, March 12, 2004 4:21 PM
Subject: Re: Function to compress text, not encrypt


> What are you going to be compressing?
> Numbers or strings?
>
> 11 is a two-digit number, are there more of the same?
>
> maa
>
>
> At 03:14 PM 3/12/2004, you wrote:
> >Hi, is there a function to compress test
> >for example 11 you can compress to K (11th letter).
> >to optimize storage in data rarely queried.
> >
> >Thanks
>
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
> put 'unsubscribe' in the subject line.
> --
> Archives are at //www.freelists.org/archives/oracle-l/
> FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------


----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------


----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------


----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 03-2004