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

  • 0
  • 1
  • Problem
  • Updated 4 years 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 4 years ago

  • 0
  • 1
Photo of Scott MacDonald

Scott MacDonald, Staff Engineer

  • 2,522 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.