LOB compression

From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Thu, 28 Jul 2011 01:10:14 +0000 (UTC)
Message-ID: <pan.2011.07.28.01.10.14_at_gmail.com>

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

Received on Wed Jul 27 2011 - 20:10:14 CDT