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;

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

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

ACTION                  VERSION      COMMENTS
------------------------------ ---------- -------------------------
APPLY                  11.2.0.2  Patchset 11.2.0.2.0
APPLY                  11.2.0.2  Patchset 11.2.0.2.0
APPLY                  11.2.0.2  PSU 11.2.0.2.2
APPLY                  11.2.0.2  PSU 11.2.0.2.3

--
http://mgogala.byethost5.com

Replies