Skip to Content

Compression and reorg on

Hello all,

A bit of a complicated situation:

I have an ABAP only ERP 2004 system running on Oracle . The system has still the old tablespace layout, i.e., I have










One of my tablespaces (PSAPSTABD) contains tables that were encrypted using Oracle Trasparent Data Encryption when Oracle was in version

I have now a new requirement to compress the database using the new functionality provided in Oracle 11 and use the new tablespace layout (PSAPSR3, PSAPSR3700 etc). Obviously, the encrypted tables of PSAPSTABD will be moved to PSAPSR3 and will be compressed. Do you know of or anticipate any issues with that?

Many thanks


Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Posted on Jul 20, 2011 at 04:37 PM

    Hello Andreas,

    well at first you should upgrade to

    There were some serious problems with (not just performance issues - found also several problems through MOS) - SAP also fixed the sapnote #1436352 with this information:

    Oracle Database Release or higher +

    SAP December 2010 Bundle Patch or later

    (to achieve good performance against OLTP compressed tables)



    Add a comment
    10|10000 characters needed characters exceeded

    • Stefan, thank you, that is very helpful.

      I did another compression of a BI 7.0 system back in mid May. I was then at and I had issues with the actual compression process, it was getting stuck with ORA-07445. After I applied patch (note 1477787) I was ok.

      We have upgrades scheduled for August-September . I might try to do the compression with again for this ERP system, as it is just a sandbox.

      That paragraph in the note regarding having at least must have been added pretty recently then? I do not remember it seeing it in May when I read the note first time.

      Many thanks again


Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.