Skip to Content
avatar image
Former Member

After oracle 11g upgrade, how compress table in SAP ECC 6.0

Hi,

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

  • Get RSS Feed

2 Answers

  • Best Answer
    Sep 17, 2011 at 11:44 AM

    Start reading the following notes:

    Note 1289494 - FAQ: Oracle compression

    Note 1436352 - Oracle 11g Advanced Compression for SAP Systems

    Note 1431296 - LOB conversion and table compression with BRSPACE 7.20

    Markus

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hello Manas,

      yes of course. This procedure works the same on all tablespaces. You can use the procedure from SAP note 1431296 for all SAP data tablespaces you have.

      Regards,

      Mark

  • avatar image
    Former Member
    Oct 11, 2013 at 07:44 PM

    Dear All,

    I am also having the query that i am having the below tablespace

    PSAPSR3

              PSAPSR3700

              PSAPSR3FACT

              PSAPSR3ODS

              PSAPSR3USR

              PSAPTEMP

              PSAPUNDO

              SYSAUX

              SYSTEM

    I have created new sapdata5 to 8 .....

    i will run the 6 command which is mention in sap note 1431296

    for

    PSAPSR3Z,PSAPSR3700Z,PSAPSR3FACTZ,PSAPSR3ODSZ,PSAPSR3USRZ,

    PSAPTEMPZ, and PSAPUNDOZ

    then how to move sysaux and system to sapdata5 to 8 .....

    please help me on the same

    Rableen

    Add comment
    10|10000 characters needed characters exceeded