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:
1 | impdp system/***** tables=USER.TABLE directory=EXPORT_DIR dumpfile=export_%U.dmp logfile=import.log PARALLEL=8 transform=segment_attributes:n:table |