ORA-39112:错误原因及解决办法,求大虾指点

shymol 2014-01-19 10:41:52
背景:ORACLE10G数据库迁移到11G,从10G导出后,导入11G时,部分表出现如下错误:
ORA-39112: Dependent object type COMMENT skipped, base object type TABLE:"CLOUDPIM"."T_CAB_LINKMAN_DETAIL" creation failed

哪位大虾指点下,问题原因在哪里,该如何解决?

全部错误:
ORA-39112: Dependent object type COMMENT skipped, base object type TABLE:"CLOUDPIM"."T_CAB_API_LOG" creation failed
ORA-39112: Dependent object type COMMENT skipped, base object type TABLE:"CLOUDPIM"."T_CAB_API_LOG" creation failed
ORA-39112: Dependent object type COMMENT skipped, base object type TABLE:"CLOUDPIM"."T_CAB_API_LOG" creation failed
ORA-39112: Dependent object type COMMENT skipped, base object type TABLE:"CLOUDPIM"."T_CAB_API_LOG" creation failed
ORA-39112: Dependent object type COMMENT skipped, base object type TABLE:"CLOUDPIM"."T_CAB_API_LOG" creation failed
ORA-39112: Dependent object type COMMENT skipped, base object type TABLE:"CLOUDPIM"."T_CAB_LINKMAN_RECYCLEBIN" creation failed
ORA-39112: Dependent object type COMMENT skipped, base object type TABLE:"CLOUDPIM"."T_CAB_PIM_LOG" creation failed
ORA-39112: Dependent object type COMMENT skipped, base object type TABLE:"CLOUDPIM"."T_CAB_PIM_LOG" creation failed
ORA-39112: Dependent object type COMMENT skipped, base object type TABLE:"CLOUDPIM"."T_CAB_PIM_LOG" creation failed
ORA-39112: Dependent object type COMMENT skipped, base object type TABLE:"CLOUDPIM"."T_CAB_PIM_LOG" creation failed
ORA-39112: Dependent object type COMMENT skipped, base object type TABLE:"CLOUDPIM"."T_CAB_PIM_LOG" creation failed
ORA-39112: Dependent object type COMMENT skipped, base object type TABLE:"CLOUDPIM"."T_CAB_LINKMAN_PHONE_INDEX" creation failed
ORA-39112: Dependent object type COMMENT skipped, base object type TABLE:"CLOUDPIM"."T_CAB_LINKMAN_PHONE_INDEX" creation failed
ORA-39112: Dependent object type COMMENT skipped, base object type TABLE:"CLOUDPIM"."T_CAB_LINKMAN" creation failed
ORA-39112: Dependent object type COMMENT skipped, base object type TABLE:"CLOUDPIM"."T_CAB_LINKMAN" creation failed
ORA-39112: Dependent object type COMMENT skipped, base object type TABLE:"CLOUDPIM"."T_CAB_LINKMAN" creation failed
ORA-39112: Dependent object type COMMENT skipped, base object type TABLE:"CLOUDPIM"."T_CAB_LINKMAN" creation failed
ORA-39112: Dependent object type COMMENT skipped, base object type TABLE:"CLOUDPIM"."T_CAB_LINKMAN_DETAIL" creation failed
...全文
12539 2 打赏 收藏 转发到动态 举报
写回复
用AI写文章
2 条回复
切换为时间正序
请发表友善的回复…
发表回复
多壮志 2014-01-25
  • 打赏
  • 举报
回复
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 --- 先看下依赖什么对象,把那个对象先倒入,然后再倒入这个对象。
  • 打赏
  • 举报
回复
查看COMMENT对象类型基于什么对象,该对象是否创建成功。 如果实在不行,IMPDP执行完毕后,手工创建COMMENT对象类型的基对象和COMMENT对象。

3,499

社区成员

发帖
与我相关
我的任务
社区描述
Oracle 高级技术相关讨论专区
社区管理员
  • 高级技术社区
加入社区
  • 近7日
  • 近30日
  • 至今
社区公告
暂无公告

试试用AI创作助手写篇文章吧