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

Hi,

When you export tables on Exadata and import them on Non Exadata database, you can get ” ORA-64307: Exadata Hybrid Columnar Compression is not supported for tablespaces on this storage type ” error.

 

When I import a dump, i got the following error.

 

CREATE TABLE "MSD"."BILLING_FREQUENCY_VALUES" ("BILLING_FREQUENCY" NUMBER(3,0) NOT NULL ENABLE, "LANGUAGE_CODE" NUMBER(6,0) NOT NULL ENABLE, "SHORT_DISPLAY" VARCHAR2(15 BYTE), "DISPLAY_VALUE" VARCHAR2(240 BYTE) NOT NULL ENABLE) SEGMENT CREATION IMMEDIATE PCTFREE 0 PCTUSED 40 INITRANS 1 MAXTRANS 255 COLUMN STORE COMPRESS FOR QUERY HIGH NO ROW LEVEL LOCKING NOLOGGING STORAGE(INITIAL 81920 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "DEFAULT_TBS2"

ORA-39083: Object type TABLE:"MSD"."DEVICEFULLINFO" failed to create with error:
ORA-64307: Exadata Hybrid Columnar Compression is not supported for tablespaces on this storage type

Failing sql is:
CREATE TABLE "MSD"."DEVICEFULLINFO" ("TAC" VARCHAR2(24 BYTE), "MARKETINGNAME" VARCHAR2(1500 BYTE), "MANUFACTURER" VARCHAR2(765 BYTE), "MODELNAME" VARCHAR2(765 BYTE), "UAPROFILE" VARCHAR2(1500 BYTE), "SUPPORTEDWIRELESSTECHNOLOGIES" VARCHAR2(4000 BYTE), "SOFTWAREVERSION" VARCHAR2(765 BYTE), "MMSMAXCAPASITE" VARCHAR2(765 BYTE), "WAPGPRS" VARCHAR2(150 BYTE), "GPRSINTERNET" VARCHAR2(150 BYTE), "WAPPUSH" VARCHAR2(150 BYTE), "OSINFORMATION" VARCHAR2(450 BYTE), "OSINFOVERSION" VARCHAR2(450 BYTE), "OSGROUP" VARCHAR2(450 BYTE), "EDGESUPPORT" VARCHAR2(150 BYTE), "WLANSUPPORT" VARCHAR2(150 BYTE), "FMRADIO" VARCHAR2(150 BYTE), "WIMAXSUPPORT" VARCHAR2(150 BYTE), "QWERTYKEYBOARD" VARCHAR2(150 BYTE), "HSDPASUPPORT" VARCHAR2(150 BYTE), "TOCUHSCREEN" VARCHAR2(150 BYTE), "HSUPASUPPORT" VARCHAR2(150 BYTE), "BTSUPPORT" VARCHAR2(150 BYTE), "HARICIBELLEKTIPI" VARCHAR2(150 BYTE), "USBSUPPORT" VARCHAR2(150 BYTE), 


ORA-39083: Object type TABLE:"MSD"."TEST" failed to create with error:
ORA-64307: Exadata Hybrid Columnar Compression is not supported for tablespaces on this storage type

 

Hybrid Columnar Compression feature is supported only Exadata and Sun ZFS storage appliance, Pillar Axiom storage systems.

So if you will import it non Exadata environment, you should use the “transform = segment_attributes: n: table” parameter to convert it.

 

 

Add transform = segment_attributes: n: table parameter to the import, it will be solved.

 transform = segment_attributes: n: table

 

 

impdp \"/ as sysdba\" SCHEMAS=MSD directory=PUMP dumpfile=TREE_DEFINITION%U.dmp logfile=TREE_DEFINITION.log cluster=n parallel=4 TABLE_EXISTS_ACTION=replace transform = segment_attributes: n: table

 

 

Do you want to learn Oracle Database for Beginners, then read the following articles.

https://ittutorial.org/oracle-database-19c-tutorials-for-beginners/

 

About Mehmet Salih Deveci

I am Founder of SysDBASoft IT and IT Tutorial and Certified Expert about Oracle & SQL Server database, Goldengate, Exadata Machine, Oracle Database Appliance administrator with 10+years experience.I have OCA, OCP, OCE RAC Expert Certificates I have worked 100+ Banking, Insurance, Finance, Telco and etc. clients as a Consultant, Insource or Outsource.I have done 200+ Operations in this clients such as Exadata Installation & PoC & Migration & Upgrade, Oracle & SQL Server Database Upgrade, Oracle RAC Installation, SQL Server AlwaysOn Installation, Database Migration, Disaster Recovery, Backup Restore, Performance Tuning, Periodic Healthchecks.I have done 2000+ Table replication with Goldengate or SQL Server Replication tool for DWH Databases in many clients.If you need Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS Consultancy and Training you can send my email adress [email protected].-                                                                                                                                                                                                                                                 -Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS ve linux Danışmanlık ve Eğitim için  [email protected] a mail atabilirsiniz.

Leave a Reply

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