首页 > 代码库 > impdp导入报错ORA-14460: only one COMPRESS or NOCOMPRESS clause may be specified
impdp导入报错ORA-14460: only one COMPRESS or NOCOMPRESS clause may be specified
迁移环境
源:Solaris 10 + Oracle 11.2.0.3
目标:Solaris 10 + Oracle 11.2.0.1
导出命令:
expdp user/pwd directory=jy content=metadata_only tables=xxx,xxx,xxx exclude=statistics dumpfile=expdp_xxx.dmp logfile=expdp_xxx.log version=‘11.2.0.1.0‘
导入命令:
impdp user/pwd directory=jy remap_schema=user1:user2 remap_tablespace=tbs1:tbs4,tbs2:tbs4,tbs3:tbs4 dumpfile=expdp_xxx.dmp log=impdp_xxx.log
1.导入过程中报错:
Processing object type TABLE_EXPORT/TABLE/TABLEORA-39083: Object type TABLE:"XXXXXXXXX"."XXX_XXXXXX_XXXXX_XXXXX_XXX" failed to create with error:ORA-14460: only one COMPRESS or NOCOMPRESS clause may be specifiedFailing sql is:
$ oerr ora 1446014460, 00000, "only one COMPRESS or NOCOMPRESS clause may be specified"// *Cause: COMPRESS was specified more than once, NOCOMPRESS was specified more// than once, or both COMPRESS and NOCOMPRESS were specified.// *Action: specify each desired COMPRESS or NOCOMPRESS clause option only once.
2.网上搜到的相关资料:
转载地址: http://www.cnblogs.com/jyzhao/articles/3956816.html
3.最终解决方法:
导入命令加入 transform=segment_attributes:n
这样就可以成功导入之前导入失败的表。
impdp导入报错ORA-14460: only one COMPRESS or NOCOMPRESS clause may be specified
声明:以上内容来自用户投稿及互联网公开渠道收集整理发布,本网站不拥有所有权,未作人工编辑处理,也不承担相关法律责任,若内容有误或涉及侵权可进行投诉: 投诉/举报 工作人员会在5个工作日内联系你,一经查实,本站将立刻删除涉嫌侵权内容。