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

使用impdp导出数据时碰到ora-39006错误,错误提示如下所示:

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

初看到internal error的错误提示,下了一跳。Google一番的结果如下:

  1.  
    Cause: The Data Pump could not use the Metadata API. Typically, this is caused by the XSL stylesheets not being set up properly.
  2.  
    Action: Connect AS SYSDBA and execute dbms_metadata_util.load_stylesheets to reload the stylesheets.

数据泵无法使用元数据API,需要以sysdba身份登录,执行:

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

  

转载于:https://www.cnblogs.com/zhangmingcheng/p/10245489.html

posted on 2021-07-22 09:10  阿陶学长  阅读(600)  评论(0编辑  收藏  举报