IMPDP ORA-14460: only one COMPRESS or NOCOMPRESS clause may be specified
来源:互联网 发布:omp算法matlab代码 编辑:程序博客网 时间:2024/05/20 07:58
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>
- IMPDP ORA-14460: only one COMPRESS or NOCOMPRESS clause may be specified
- IMPDP ORA-14460: only one COMPRESS or NOCOMPRESS clause may be specified
- ORA-14460: only one COMPRESS or NOCOMPRESS clause may be specified
- impdp分区表导入错误ORA-14460: 只能指定一个 COMPRESS 或 NOCOMPRESS 子句
- there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE clause
- there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE clause
- 数据库建表 there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE clause
- Only one Looper may be created per thread
- Only one Looper may be created per thread
- Only one SparkContext may be running in this JVM
- ORA-10631: SHRINK clause should not be specified for this object
- ORA-10631: SHRINK clause should not be specified for this object
- 关于IAR报 more than one storage class may not be specified 错误的问题
- ORA-13504: No SYSAUX datafile clause specified
- ORA-13504: No SYSAUX datafile clause specified
- 【遇见Android bug】Only one Looper may be created per thread
- java.lang.RuntimeException: Only one Looper may be created per thread
- Spark Q&A : Only one SparkContext may be running in this JVM
- 关于数组的初值
- 家乡的小河
- 【IMPDP】使用 TRANSFORM选项去掉表空间和存储子句
- 粘贴 乱码
- 将dll从进程模块列表中移除并保持正常运行
- IMPDP ORA-14460: only one COMPRESS or NOCOMPRESS clause may be specified
- plsql工具比较用户对象
- iOS常用代码
- android apk
- fusioncharts的属性介绍
- 进程和线程(android)
- 简单 却爱
- 类中线程的使用
- 面向对象三要素