We have created a VDB from a database residing on Exadata. Some of the tables/partitions on the exadata side use the HCC compression feature. When you attempt to access those partitions or tables on the VDB you get the above error. Has Delphix any workaround to this or suggestions?
Unfortunately HCC compressed data cannot be accessed from Delphix storage, due to Oracle restrictions. The HCC data needs to be uncompressed before it is linked as a dSource in Delphix, something like an 'ALTER TABLE ... MOVE' type command.
An alternative and simpler possibility is to ingest data compressed with HCC, then, at the time of VDB provisioning, a hook can be invoked to decompress the HCC-compressed objects. In this way, source still continues using HCC and VDB can perform correctly.