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

Yesterday I was importing a dumpfile using Datapump utility and I faced below mentioned error :-

Import: Release 11.2.0.1.0 - Production on Tue Dec 09 09:14:11 2013

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Master table  "AMIT" ."SYS_IMPORT_FULL_01" successfully loaded/unloaded
Starting  "AMIT" ."SYS_IMPORT_FULL_01":  amit/******** directory=datapump dumpfile=expdp_amit_04.dmp logfile=impdp_amit_01.log remap_schema=amit21:amit TRANSFORM=STORAGE:n
Processing object type TABLE_EXPORT/TABLE/TABLE
ORA-39083: Object type TABLE:"AMIT"."TEST" failed to create with error:
ORA-14460: only one COMPRESS or NOCOMPRESS clause may be specified
Failing sql is:
CREATE TABLE "AMIT"."TEST" ("ID" NUMBER(12) , "NAME" VARCHAR2(20 BYTE)
ORA-39083: Object type TABLE:"AMIT"."TEST" failed to create with error:
ORA-14460: only one COMPRESS or NOCOMPRESS clause may be specified

Solution :-

Use TRANSFORM=segment_attributes:n in IMPDP

impdp amit/amit directory=datapump dumpfile=expdp_amit_04.dmp logfile=impdp_amit_01.log remap_schema=amit21:amit TRANSFORM=STORAGE:n,segment_attributes:n &

Import: Release 11.2.0.1.0 - Production on Tue Dec 09 09:15:49 2013

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

Master table  "AMIT" ."SYS_IMPORT_FULL_01" successfully loaded/unloaded

Starting  "AMIT" ."SYS_IMPORT_FULL_01":  amit/******** directory=datapump dumpfile=expdp_amit_04.dmp logfile=impdp_amit_01.log remap_schema=amit21:amit TRANSFORM=STORAGE:n,SEGMENT_ATTRIBUTES:n &

Processing object type TABLE_EXPORT/TABLE/TABLE

Processing object type TABLE_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT

Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS

Job "INCMS2_MG"."SYS_IMPORT_FULL_01" completed at 09:16:34

I hope this article helped you.

Regards,

Amit Rath