Skip to Content
avatar image
Former Member

Oracle Advanced Compression and BLOBs

Hello,

I am using brspace 7.20 and Oracle 11.2.0.1.0 to compress

the contents of a tablespace:

brspace -f tbreorg -a long2lob -c ctablob -s PSAPOLD -t PSAPNEW
brspace -f tbreorg -a lob2lob -c ctablob -s PSAPOLD -t PSAPNEW
brspace -f tbreorg -a reorg -c ctab -s PSAPOLD -t PSAPNEW

Now some tables still remain in PSAPOLD and brspace explains it like this:

BR1914W Table SAPR3.FPLOG is a SAP compressed table

BR1111I Reorganization of table SAPR3.FPLOG will be skipped

Did I miss something? I thought SAP note 1431296 is pretty clear on

how to implement Oracle Advaced Compression. Why does brspace

skip all tables with BLOB fields?

Regards,

Mark

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Jun 17, 2010 at 03:42 PM

    Hello Mark,

    compression is only possible with Secure Files .. not the basic LOB.

    Have you checked if the BR*Tools have converted the basic LOBs to Secure Files?

    Until now i have not investigated 11g R2 with its features on a SAP environment (planned for Q3/2010), but this should be the case. If the LOBs are still the basic LOBs .. enable tracing of the conversion for one table which contains some LOBs to get some details.

    Regards

    Stefan

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Stefan Koehler

      Hello Stefan,

      I finally sorted out what was going wrong. I underestimated the number of SAP pool and cluster tables.

      There are 949 pool and cluster tables in my ECC 6.0 system, and the command line option -SCT

      excludes them correctly for both (table and LOB) compression.

      Now everything is fine and the correct brspace usage is clear for me.

      Regards,

      Mark

      Edited by: Mark Foerster on Jun 22, 2010 10:25 AM

  • avatar image
    Former Member
    Sep 17, 2011 at 11:25 AM

    Hi Mark,

    Can you help me after oracle 11g upgrade, how compress table in SAP ECC 6.0?

    Thanks,

    Manas

    Add comment
    10|10000 characters needed characters exceeded