ORA-00439: feature not enabled: Dump File Data Compression during expdp
My database version is:
SQL> select * from v$version;
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Release 11.2.0.1.0 - 64bit Production
PL/SQL Release 11.2.0.1.0 - Production
CORE 11.2.0.1.0 Production
TNS for Linux: Version 11.2.0.1.0 - Production
NLSRTL Version 11.2.0.1.0 - Production
SQL> show parameter compatible
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
compatible string 11.2.0.0.0
However when I tried to do this:
expdp system directory=data_pump_dir dumpfile=prod_schema.dmp schemas=a,b logfile=prod-schema.log compression=all>
Export: Release 11.2.0.1.0 - Production on Thu Jan 12 08:39:48 2012
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
Password:
Connected to: Oracle Database 11g Release 11.2.0.1.0 - 64bit Production
ORA-39002: invalid operation
ORA-00439: feature not enabled: Dump File Data Compression
It is on linux.
Thanks,