ORA-64307: Exadata Hybrid Columnar Compression is not supported for tablespaces on this storage type
November 8, 2024
When you try to import an 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 process 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 exporting a database using Hybrid Columnar Compression to a database that does not support HCC, tables like this need to be transformed. For transformation, the “transform=segment_attributes:n:table” parameter must be given with the import.
Sample import command:
impdp system/***** tables=USER.TABLE directory=EXPORT_DIR dumpfile=export_%U.dmp logfile=import.log PARALLEL=8 transform=segment_attributes:n:table
