【转载】ORA-14460: only one COMPRESS or NOCOMPRESS clause may be specified

原文地址：http://heliosguneserol.com/2012/04/13/ora-14460-only-one-compress-or-nocompress-clause-may-be-specified/

ORA-14460: only one COMPRESS or NOCOMPRESS clause may be specified

I face with ORA-14460: only one COMPRESS or NOCOMPRESS clause may be specified error message during making Export table from 11.2.0.2 RAC database to 11.2.0.1 RAC database on AIX 6.1.

My export command is:

expdp user/password@SID tables=Myschema.XXX,Myschema.YYY directory=EXPDP_DIR DUMPFILE=dump2%U.dmp PARALLEL=3 logfile=MyExport.log

My Import command is:

impdp user/password@SID2 directory=impdp_dir dumpfile=dump2%U.dmp REMAP_SCHEMA=Myschema:Newschema remap_tablespace=MyschemaTs01:NewTs01 TABLE_EXISTS_ACTION=APPEND logfile=MyImport.log

The error message is:

Failing sql is:
CREATE TABLE “Newschema”.”XXX” (“HEADER_ID” VARCHAR2(30 CHAR), “LINE_NUMBER” NUMBER(20,0), “ACCOUNT” VARCHAR2(15 CHAR),
ORA-39083: Object type TABLE:”Newschema”.”XXX” failed to create with error:
ORA-14460: only one COMPRESS or NOCOMPRESS clause may be specified
Failing sql is:
CREATE TABLE “Newschema”.”XXX” (“HEADER_ID” VARCHAR2(30 CHAR), “BRANCH_NAME” VARCHAR2(4 CHAR),
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
ORA-31693: Table data object “Newschema”.”XXX”:”P20120410″ failed to load/unload and is being skipped due to error:
ORA-00942: table or view does not exist

Solution:

impdp user/password@SID2 directory=imp_dir dumpfile=dump2%U.dmp REMAP_SCHEMA=Myschema:Newschema remap_tablespace=MyschemaTs01:NewTs01 TABLE_EXISTS_ACTION=APPEND transform=segment_attributes:n logfile=MyImport.log