my question is simple:
If I execute this SQL:
ALTER TABLE some_table_name MOVE COMPRESS;
and the table is already compressed, will Oracle skip or spend time re-compressing ?
The reason why I am asking is because I have some nice PL/SQL that loops through all the tables
in my schema, I have about 1800 tables and it compresses them, but it takes a long time,
hours
and I only would want to compress the Tables that aren't already compressed, if compressed, skip, so
that's why I am asking.... trying to determine if the PL/SQL needs a tweak or not :- )