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

1. 
   Issue:

    

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

    

   Detail:

    

   On importing schema i got following message:

    

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

   With the Partitioning option

   Starting "SCAN"."SYS_IMPORT_SCHEMA_01":  SCAN/********@ora parfile=scan.par

   Estimate in progress using BLOCKS method...

   Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA

   Total estimation using BLOCKS method: 0 KB

   Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA

   Processing object type SCHEMA_EXPORT/TYPE/TYPE_SPEC

   Processing object type SCHEMA_EXPORT/TABLE/TABLE

   ORA-39083: Object type TABLE:"SCAN"."TABLE1" failed to create with error:

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

   Failing sql is:

   CREATE TABLE "ora_user"."table1" ("ID" NUMBER(10,0) NOT NULL ENABLE, "IMAGE" BLOB, "TYPE" VARCHAR2(10 BYTE), "SCAN_DATE" TIMESTAMP (6) DEFAULT sysdate NOT NULL ENABLE) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255  STORAGE( BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "SCAN"  LOB ("IMAGE") STORE AS BASICFILE (ENABLE S

   . . imported "SCAN"."OBJECT"                                  4 rows

   ...

    

   Here i am restoring Oracle 11.2.0.2 schema dump at Oracle 11.2.0.1 database.

    

   Solution:

    

   Use impdp with transform=segment_attributes:n cluse.

    

   eg.

    

   $ impdp systems/sys transform=segment_attributes:n

    

   Some other parameter like remap_tablespace may not work in this senario.

    

    

    

   源文档 <http://www.dbas-oracle.com/2011/10/impdp-ora-14460-only-one-compress-or.html>