ORA-00439: feature not enabled: Basic Compression
10,580
You can use the TRANSFORM
parameter to turn off compression on the import. This worked while attempting to import onto the Oracle version running in Amazon RDS
https://docs.oracle.com/database/121/SUTIL/GUID-64FB67BD-EB67-4F50-A4D2-5D34518E6BDB.htm#SUTIL939
Author by
Subbu
Updated on November 26, 2022Comments
-
Subbu 12 months
I have a dump file which is exported from Oracle 11G enterprise edition (Server1). Now, i'm trying to import the same dump file into oracle 11G express edition (Server2).
I'm getting many errors and looks like the following error is a root error.
ORA-39083: Object type TABLE:"CCEFS"."CIP_USERS" failed to create with error: ORA-00439: feature not enabled: Basic Compression Failing sql is: CREATE TABLE "CCEFS"."CIP_USERS" ( "RECKEY" NUMBER(*,0) NOT NULL ENABLE, "USER_ID" VARCHAR2(50 BYTE), "NAME" VARCHAR2(50 BYTE), "ADMIN" VARCHAR2(1 BYTE), "DISABLE" VARCHAR2(1 BYTE) DEFAULT 'N', "CRE_DT" DATE DEFAULT sysdate, "CRE_USR" VARCHAR2 (50 BYTE), "UPD_DT" DATE, "UPD_USR" VARCHAR2(50 BYTE), "PASSWORD" VARCHAR2 (4000 BYTE), "GUEST_USR" VARCHAR2(1 BYTE) DEFAULT
Could anyone help me on fixing the above issue? Also, please suggest the steps need to be followed while importing the dump file (exported from enterprise edition) into express edition.
-
Admin almost 2 yearsAs it’s currently written, your answer is unclear. Please edit to add additional details that will help others understand how this addresses the question asked. You can find more information on how to write good answers in the help center.