Hello everyone,
I have an odd question. I have a customer that using Exadata for production system and as you know exadata supports hybrid compression but for some budget issues they are using and Oracle Data Appliance machine as disaster system and ODA machine has standart storage not something like ZDFs etc. so their production supports hybrid compression but ODA is not! we tested that. I create a hybrid compressed table and started the disaster database and try to select it. Of course oracle gave me an error about I can not select this table because of the storage support.
Aynway, my question is this, on this system there are many tables partitioned and the old partitions are almost useless but have to kept. Let's say a LOG table, we almost never select the last year's data (very rare cases) I want to compress last year's partitions with hybrid columnar compression and leave non compressed for current year /month. any dml operation on the main table is adding to log table by trigger. So, if something bad happens and I have to switch the database to disaster, could I use this LOG table's current year/month (non compressed) partition ? I will not use any HCC partition of the LOG table at the disaster system, we do not need it. is this possible, a table contain both non-compressed and hybrid compressed partitions and using only non-compressed partitions can be selected at a non hybrid supported system ?
thanks.