impdp报ORA-39112

1. impdp导入报错

. . imported "ZHJY"."WF_VAR"                                 0 KB       0 rows
. . imported "ZHJY"."WF_WHOLE_PROPERTY"                      0 KB       0 rows
Processing object type SCHEMA_EXPORT/TABLE/COMMENT
ORA-39112: Dependent object type COMMENT skipped, base object type TABLE:"ZHJY"."ADMIN_SM_LOOKUP" creation failed

ORA-39112: Dependent object type COMMENT skipped, base object type TABLE:"ZHJY"."ADMIN_SM_LOOKUP" creation failed

ORA-39112: Dependent object type COMMENT skipped, base object type TABLE:"ZHJY"."ADMIN_SM_LOOKUP" creation failed

ORA-39112: Dependent object type COMMENT skipped, base object type TABLE:"ZHJY"."ADMIN_SM_LOOKUP" creation failed

ORA-39112: Dependent object type COMMENT skipped, base object type TABLE:"ZHJY"."ADMIN_SM_LOOKUP" creation failed

ORA-39112: Dependent object type COMMENT skipped, base object type TABLE:"ZHJY"."ADMIN_SM_LOOKUP" creation failed

ORA-39112: Dependent object type COMMENT skipped, base object type TABLE:"ZHJY"."ADMIN_SM_LOOKUP" creation failed

2.说明

使用impdp工具完成数据导入时，会按照dump文件中有关的存储的参数信息完成数据的导入。
很多情况下我们希望按照被导入用户的默认参数完成数据的导入， 此时我们可以使用impdp的transform参数辅助完成

3.解决

impdp zhjy/zhjy@zhjy dumpfile=crm_dl_org_qj.dmp directory=ORACLE_BASE remap_schema=crm_dl_org_qj:zhjy  transform=segment_attributes:n   
transform=segment_attributes:n 去掉表空间和存储子句，加上这个参数后，remap_tablesapce参数就会失效，就会倒进用户默认的表空间，