Skip to Content
0

Oracle 12 Compression level

Sep 28, 2017 at 01:43 PM

52

avatar image
Former Member

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Prithviraj Rajpurohit Sep 28, 2017 at 02:12 PM
0

Hi

I guess this sap note should answer all your question

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

Regards,

Prithviraj

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Oct 03, 2017 at 07:12 AM
0

Hi Prithviraj

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

Regards

Urs

Share
10 |10000 characters needed characters left characters exceeded