2 Replies Latest reply on Dec 20, 2011 6:59 PM by user1862659

    Exadata and DataGuard

      Hi everyone,

      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.

      Best regards.