ORA-39006错误原因及解决办法

版权声明:本文为博主原创文章,遵循 CC 4.0 BY-SA 版权协议,转载请附上原文出处链接和本声明。
本文链接:https://blog.csdn.net/huangbaokang/article/details/78748437

oracle数据库的导入导出遇到如下问题。

这里写图片描述

网上找了好多方法,大都说是数据泵无法使用元数据API,需要以sysdba身份登录,执行:

SQL> execute dbms_metadata_util.load_stylesheets;
PL/SQL procedure successfully completed.

可是试过之后还是没用,不过我发现网上的这个错误有点不一样。网上的错误如下:

ORA-39006: internal error
ORA-39213: Metadata processing is not available

我的错误信息没有ORA-39213,为了解决这个问题,花费了不少时间,后面才知道原来是文件磁盘满了。

也是从如下错误出的灵感。删除了相关备份的大文件,顺利的解决了该问题。

这里写图片描述

专业墙纸贴纸厨房用具装饰出售,本人网店经营

博客对你有用记得访问下哦,增加下访问量,如有需要可以下单购买哦^_^。https://item.taobao.com/item.htm?id=569617707364

展开阅读全文

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

01-19

背景:ORACLE10G数据库迁移到11G,从10G导出后,导入11G时,部分表出现如下错误:rnORA-39112: Dependent object type COMMENT skipped, base object type TABLE:"CLOUDPIM"."T_CAB_LINKMAN_DETAIL" creation failedrnrn哪位大虾指点下,问题原因在哪里,该如何解决?rnrn全部错误:rnORA-39112: Dependent object type COMMENT skipped, base object type TABLE:"CLOUDPIM"."T_CAB_API_LOG" creation failedrnORA-39112: Dependent object type COMMENT skipped, base object type TABLE:"CLOUDPIM"."T_CAB_API_LOG" creation failedrnORA-39112: Dependent object type COMMENT skipped, base object type TABLE:"CLOUDPIM"."T_CAB_API_LOG" creation failedrnORA-39112: Dependent object type COMMENT skipped, base object type TABLE:"CLOUDPIM"."T_CAB_API_LOG" creation failedrnORA-39112: Dependent object type COMMENT skipped, base object type TABLE:"CLOUDPIM"."T_CAB_API_LOG" creation failedrnORA-39112: Dependent object type COMMENT skipped, base object type TABLE:"CLOUDPIM"."T_CAB_LINKMAN_RECYCLEBIN" creation failedrnORA-39112: Dependent object type COMMENT skipped, base object type TABLE:"CLOUDPIM"."T_CAB_PIM_LOG" creation failedrnORA-39112: Dependent object type COMMENT skipped, base object type TABLE:"CLOUDPIM"."T_CAB_PIM_LOG" creation failedrnORA-39112: Dependent object type COMMENT skipped, base object type TABLE:"CLOUDPIM"."T_CAB_PIM_LOG" creation failedrnORA-39112: Dependent object type COMMENT skipped, base object type TABLE:"CLOUDPIM"."T_CAB_PIM_LOG" creation failedrnORA-39112: Dependent object type COMMENT skipped, base object type TABLE:"CLOUDPIM"."T_CAB_PIM_LOG" creation failedrnORA-39112: Dependent object type COMMENT skipped, base object type TABLE:"CLOUDPIM"."T_CAB_LINKMAN_PHONE_INDEX" creation failedrnORA-39112: Dependent object type COMMENT skipped, base object type TABLE:"CLOUDPIM"."T_CAB_LINKMAN_PHONE_INDEX" creation failedrnORA-39112: Dependent object type COMMENT skipped, base object type TABLE:"CLOUDPIM"."T_CAB_LINKMAN" creation failedrnORA-39112: Dependent object type COMMENT skipped, base object type TABLE:"CLOUDPIM"."T_CAB_LINKMAN" creation failedrnORA-39112: Dependent object type COMMENT skipped, base object type TABLE:"CLOUDPIM"."T_CAB_LINKMAN" creation failedrnORA-39112: Dependent object type COMMENT skipped, base object type TABLE:"CLOUDPIM"."T_CAB_LINKMAN" creation failedrnORA-39112: Dependent object type COMMENT skipped, base object type TABLE:"CLOUDPIM"."T_CAB_LINKMAN_DETAIL" creation failed 论坛

没有更多推荐了,返回首页