Skip to main content
Skip table of contents

Oracle compression licensing

As an Enterprise Edition is needed for key compression as of version 12c, the "compress" instruction is now removed from create-db.sql script. It cannot be used for new databases.

Disable indexes with compression='ENABLED'

To disable indexes with compression='ENABLED' for already existing databases use the following statement:

CODE
DECLARE
BEGIN
FOR index_entry IN (select INDEX_NAME from user_indexes where compression='ENABLED')
LOOP
dbms_output.put_line('INFO: working on ' || index_entry.INDEX_NAME);
EXECUTE IMMEDIATE 'ALTER INDEX ' || index_entry.INDEX_NAME || ' REBUILD NOCOMPRESS';
END LOOP;
END;

To switch on 'compression' back to 'ENABLED' the script 'create-db-enterprise-edition.sql' must be executed. This requires that an Enterprise Edition has been purchased by the customer.

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.