Impdp import error ORA-14460: Only one compress or nocompress clause may be specified

Migration Environment

Source: Solaris 10 + Oracle 11.2.0.3

Target: Solaris 10 + Oracle 11.2.0.1

Export command:

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‘

Import command:

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. An error is reported during the import process:

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. Related information found on the Internet: Reprinted address: http://www.cnblogs.com/jyzhao/articles/3956816.html 3. The final solution: Import command to add Transform = segment_attributes: NIn this way, you can import tables that failed to be imported.

Impdp import error ORA-14460: Only one compress or nocompress clause may be specified