1 Reply Latest reply: Jan 24, 2008 4:02 PM by 137669 RSS

    Oracle 9.2 Compress LOB SEGMENT

    483527
      Hi

      I have a table with a BLOB column

      create table t (..., blob_column BLOB, ...) LOB (blob_column) STORE AS (tablespace lobts ...)


      In Oracle 11g it is possible to use COMPRESS [HIGH | MEDIUM] option for LOB storage

      I am using Oracle 9.2 and I would like to keep the BLOB data compressed in the tablespace lobts

      What if set tablespace lobts to have DEFAULT COMPRESS option:

      ALTER TABLESPACE lobts DEFAULT COMPRESS;

      Does this guaranty that all BLOB data inserted in the table to be compressed?

      Thank you for your help
      Taoufik
        • 1. Re: Oracle 9.2 Compress LOB SEGMENT
          137669
          The BLOB compression is a new feature of Oracle 11g.

          So why should it be possible to use this feature in a Oracle version which is about 5 years older? How should the DB be able to read compressed lob data if the lob compression feature is not implemented...