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

Share:
10,580
Subbu
Author by

Subbu

Updated on November 26, 2022

Comments

  • Subbu
    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
    Admin almost 2 years
    As 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.