SAP Knowledge Base Article - Preview

3555014 - ORA-39726 Error Occurs After Database Upgrade

Symptom

  • During a database upgrade from Oracle 12c to 19c, an error occurs while applying a change request that involves adding a field to a table.
  • The error message displayed is "ORA-39726: unsupported add/drop column operation on compressed tables".
  • The system has already applied note 2157904 as the latest version, and the compress option of the table is confirmed to be set to advance.


Read more...

Environment

Oracle

Keywords

ORA-39726, database upgrade, Oracle 12c, Oracle 19c, add/drop column operation, compressed tables, note 2157904, BASIC compression level, ADVANCED compression level, sysdba, adjust_compression, sap_schema. , KBA , BC-DB-ORA , Oracle , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.