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.