I have a doubt with Exadata and DG. Suppose a table with different types of compression. This is, a range partitioned table with the first N partitions compressed with HCC. From N+1 to N+M the table has been partitioned with native 11.2 compression and for the last partitions with no compression. The environment consists of a primary Exadata database and a standby non-Exadata database. In case of switchover/failover, when accessing to compressed data with HCC, I should execute an alter table ... move nocompress. My question is, Could I execute the command only for partitions with HCC compression?. Really only the first partitions are compressed with such criteria and it should not be necessary a lock on the whole table, only for the first partitions.
In a partitioned table, "ALTER TABLE MOVE" can only be done at the partition level, not at the table level. So yes, you only need to rebuild the actual partitions with hybrid columnar compression.