Installation and Upgrade › Known Issues › CA Clarity PPM Upgrade and Oracle Enterprise Table Compression

CA Clarity PPM Upgrade and Oracle Enterprise Table Compression

If you are using the Oracle Enterprise Edition compression feature, disable the compression feature before starting the CA Clarity PPM upgrade. If the compression feature is enabled, the upgrade fails with the following Oracle database error:

[CA Clarity][Oracle JDBC Driver][Oracle]ORA-39726: unsupported add/drop column operation on compressed tables

The following procedure explains how to get ready for the upgrade by disabling compression. Once the procedure is complete, you can proceed with the upgrade. When the upgrade has successfully completed, you can compress the tables again.

To prepare for the upgrade, complete the following steps:

1. Identify compressed tables by executing the following query:

   SELECT TABLE_NAME, COMPRESSION FROM USER_TABLES WHERE COMPRESSION='ENABLED';
   

2. Disable compression. Run the output of this query. Keep this list handy, so that these tables can be compressed again after the upgrade.

   SELECT 'ALTER TABLE ' || TABLE_NAME || ' MOVE NOCOMPRESS;'  FROM USER_TABLES WHERE COMPRESSION='ENABLED';
   

3. Rebuild the unusable indexes. Run the output of this query:

   SELECT 'ALTER INDEX ' || INDEX_NAME || ' REBUILD;' FROM USER_INDEXES WHERE STATUS='UNUSABLE';