Expdp Export Failed: ORA-00439: feature not enabled: Dump File Data Compression

Error Description:

Data pump expdp export failed with following error

Connected to: Oracle Database 11g Release 11.2.0.3.0 - 64bit Production

ORA-39002: invalid operation

ORA-00439: feature not enabled: Dump File Data Compression

Solution Description:

The advanced compression options of oracle works only with Enterprise Edition. I have used compression=all option and the Oracle version which I am using is standard edition. That is the reason for the error.

You have to remove the compression option from the expdp command.

Another option is you can use legacy exp command with OS (Unix) compression commands. See this Link

You can check your oracle version using following query.

1.   Standard Edition

$ sqlplus  / as sysdba

SQL >select * from v$version

BANNER

-------------------------------------------------------------

Oracle Database 11g Release 11.2.0.3.0 - 64bit Production

2.   Enterprise Edition

SQL> select * from v$version;

BANNER

------------------------------------------------------------------

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production