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

 

When you try to import the export from a database on Exadata to a database that is not on Exadata storage, Pillar Axiom storage systems, or Sun ZFS storage appliance, the import will terminate with the ORA-64307 error.

Hybrid Columnar Compression can only be used with Exadata storage, Pillar Axiom storage systems and Sun ZFS storage appliance.

When importing the export of a database using Hybrid Columnar Compression into an HCC-unsupported database, such tables must be converted.

For a successful import, the “transform = segment_attributes: n: table” parameter must be used in the import command.

Sample Import Command:

dbtut
Author: dbtut

We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.

Leave a Reply

Your email address will not be published. Required fields are marked *