ORA-64307: hybrid columnar compression is not supported for tablespaces on this storage type on Delphix

  • 0
  • 1
  • Problem
  • Updated 1 month ago
  • Acknowledged
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?
Photo of Proinnsias Glynn

Proinnsias Glynn

  • 70 Points

Posted 5 years ago

  • 0
  • 1
Photo of Scott MacDonald

Scott MacDonald, Staff Engineer

  • 2,722 Points 2k badge 2x thumb
Official Response
Hi Proinnsias,

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.

Many Thanks,

Scott.
Photo of Matteo Ferrari

Matteo Ferrari, Employee

  • 152 Points 100 badge 2x thumb
Official Response
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.