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/