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


DBA Tips Data Pump Reference

0 comments:

Post a Comment

 

dba topics. Copyright 2011-16 All Rights Reserved | Site Map | Contact | Disclaimer | Google