Re: Function to compress text, not encrypt

From: Juan Cachito Reyes Pacheco <jreyes_at_dazasoftware.com>
Date: Fri, 12 Mar 2004 16:27:50 -0400
Message-ID: <003d01c40870$836ffb50$2501a8c0@dazasoftware.com>

Not in standard edition

CREATE TABLE ADM.A ( s VARCHAR2(1) )

compress

16:27:20 ORA-00439: función no activada: Heap segment compression

Original Message ----- From: "Justin Cave (DDBC)" <jcave_at_ddbcinc.com> To: <oracle-l_at_freelists.org> Sent: Friday, March 12, 2004 4:31 PM Subject: RE: Function to compress text, not encrypt

You can, in 9i R2 at least, use table compression.

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

-----Original Message-----

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Juan Cachito Reyes Pacheco
Sent: Friday, March 12, 2004 1:14 PM
To: oracle-l_at_freelists.org
Subject: Function to compress text, not encrypt

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_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

Please see the official ORACLE-L FAQ: http://www.orafaq.com

Received on Fri Mar 12 2004 - 14:28:31 CST