Skip to Content
avatar image
Former Member

Oracle 12 Compression level

After exporting SAP data from Oracle 11 to Oracle 12 (SAP export/import) the default compression level of tablespace PSAPSR3 was set to "BASIC".

It should be "ADVANCED" and this caused ORA-39726 (unsupported add/drop column operation on compressed tables) errors.

I could change the affected tables according SAP note 2157904, but I am afraid to have every new table in "BASIC"- compression, due to the default setting of the tablespace.

Question: Is it possible to change the compression level of the TABLESPACE itself from "BASIC" to "ADVANCED"?

Thanks in advance

Urs

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Sep 28, 2017 at 02:12 PM

    Hi

    I guess this sap note should answer all your question

    https://launchpad.support.sap.com/#/notes/2138262

    Regards,

    Prithviraj

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 03, 2017 at 07:12 AM

    Hi Prithviraj

    Thank you for your answer, I will try this ...

    Regards

    Urs

    Add comment
    10|10000 characters needed characters exceeded