39112,00000, "Dependent object type %s skipped, base object type %s creation failed" // *Cause: During a Data Pump import job, a dependent object is being skipped // because its base object creation failed. // *Action: If the object from the dump file is wanted, drop the base and // dependent objects and try to import again using desired filters
哦,忘了说了,导出是schemas导出的,报错是ORA-39112: Dependent object type COMMENT skipped, base object type VIEW:"....." creation failed我想基表都导入成功了,会有什么原因导致视图进不去呢,想不通了,继续讨论
// *Cause: During a Data Pump import job, a dependent object is being skipped
// because its base object creation failed.
// *Action: If the object from the dump file is wanted, drop the base and
// dependent objects and try to import again using desired filters
如果实在不行,IMPDP执行完毕后,手工创建COMMENT对象类型的基对象和COMMENT对象。
然后有查一下有什么依赖关系?