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

最新推荐文章于 2022-03-08 17:20:01 发布

冷月宫主

最新推荐文章于 2022-03-08 17:20:01 发布

阅读量1.1k

点赞数

分类专栏： Oracle 文章标签： schema attributes object oracle network image

Oracle 专栏收录该内容

538 篇文章 5 订阅

订阅专栏

www.dbas-oracle.com

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

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.