Altering Databases for Compression

set compression specifies the database-wide compression level, which applies only to newly created tables.

You can use set lob_compression by itself or with other set subclauses. However, other set subclauses require the database to be in single-user mode (for example, if you change the durability level of the database).