LOB compression

Giganews Newsgroups
Subject: LOB compression
Posted by:  Mladen Gogala (gogala.mlad…@gmail.com)
Date: Thu, 28 Jul 2011

I know that I need advanced compression option if I compress table for
all operations. Do I need advanced compression license if I compress just
LOB columns? The problem is licensing, I can't exceed the licenses
allotted and the company didn't purchase the advanced compression option.
DB version is:

SQL> select * from v$version;

Oracle Database 11g Enterprise Edition Release - 64bit
PL/SQL Release - Production
CORE    Production
TNS for Linux: Version - Production
NLSRTL Version - Production

SQL> select action,version,comments
  2  from dba_registry_history;

ACTION                  VERSION      COMMENTS
------------------------------ ---------- -------------------------
APPLY          Patchset
APPLY          Patchset
APPLY          PSU
APPLY          PSU