Re: Standby with a twist

On 06/22/2017 11:44 AM, Andy Klock wrote:
> I believe the apply will still do its thing, however, upon a role
> change you will get "ORA-64307: hybrid columnar compression is only
> supported in tablespaces residing on Exadata, ZFSSA, or AXIOM storage"
> when SELECTing from tables with HCC. To get around that you'd have to
> decompress every HCC'd table. I don't think this has changed in 12c
> (but somebody should correct me if I'm wrong). Cost savings aside, I'm
> not sure how helpful this would be.
>
>
> See:
> http://www.oracle.com/technetwork/database/availability/maa-wp-dr-dbm-130065.pdf
>
> Andy K

Thanks Andy! I believe that this is a reason not to buy Exadata. There is this thing called Greenplum, designed by the same guy who designed Exadata. I believe that he now works for AWS. He used to be an Oracle ACE.

-- 
Mladen Gogala
Oracle DBA
Tel: (347) 321-1217


--
http://www.freelists.org/webpage/oracle-l