From oracle-l-bounce@freelists.org Fri Mar 12 14:28:31 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i2CKSVP18607 for ; Fri, 12 Mar 2004 14:28:31 -0600 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i2CKSUo18601 for ; Fri, 12 Mar 2004 14:28:30 -0600 Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 65CC439507B; Fri, 12 Mar 2004 15:27:36 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Fri, 12 Mar 2004 15:26:27 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from mail.acelerate.com (mail.acelerate.com [200.105.128.132]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with SMTP id 1AC8C394E87 for ; Fri, 12 Mar 2004 15:26:20 -0500 (EST) Received: (qmail 13219 invoked from network); 12 Mar 2004 20:24:25 -0000 Received: from dazasoftware.com (HELO org48l7d9ara8b) (200.105.151.94) by 0 with SMTP; 12 Mar 2004 20:24:25 -0000 Message-ID: <003d01c40870$836ffb50$2501a8c0@dazasoftware.com> From: "Juan Cachito Reyes Pacheco" To: References: <87E9F113CEF1D211A4C3009027301874195D4C@ddbcinc.ddbc.local> Subject: Re: Function to compress text, not encrypt Date: Fri, 12 Mar 2004 16:27:50 -0400 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1158 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 X-archive-position: 748 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: jreyes@dazasoftware.com Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l 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)" To: 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@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of Juan Cachito Reyes Pacheco Sent: Friday, March 12, 2004 1:14 PM To: oracle-l@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@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 ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@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 ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@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 -----------------------------------------------------------------