How to fix the Oracle error ORA-64307: Exadata Hybrid Columnar Compression is not supported for tablespaces on this storage type?

In this post, you’ll learn more about the Oracle ErrorORA-64307: Exadata Hybrid Columnar Compression is not supported for tablespaces on this storage type with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-64307: Exadata Hybrid Columnar Compression is not supported for tablespaces on this storage type

Reason for the Error ORA-64307: Exadata Hybrid Columnar Compression is not supported for tablespaces on this storage type

An attempt was made to use Exadata Hybrid Columnar Compression on an unsupported storage type.

How to fix the Error ORA-64307: Exadata Hybrid Columnar Compression is not supported for tablespaces on this storage type ?

You can fix this error in Oracle by following the below steps

Create this table in a tablespace residing on Oracle Exadata, Oracle’s Sun ZFS or Pillar Axiom storage type or use a different compression type.