ITPub博客

首页 > Linux操作系统 > Linux操作系统 > expdp时候遇到ORA-04067

expdp时候遇到ORA-04067

原创 Linux操作系统 作者:myownstars 时间:2011-02-18 14:11:52 0 删除 编辑

做一次expdp时候,显示出以下错误信息
ORA-39127: unexpected error from call to export_string :=WMSYS.LT_EXPORT_PKG.schema_info_exp('justin',0,1,'11.02.00.00.00',newblock)
ORA-04067: not executed, package body "WMSYS.LT_EXPORT_PKG" does not exist
ORA-06508: PL/SQL: could not find program unit being called: "WMSYS.LT_EXPORT_PKG"
ORA-06512: at line 1
创建该缺少body,切换到$ORACLE_HOME/rdbms/admin目录,
排除了一圈才找到创建文件
[oracle@db admin]$ more owmexpb.plb | grep -i "create or replace package body wmsys.lt_export_pkg wrapped"
create or replace package body wmsys.lt_export_pkg wrapped

SQL> @owmexpb.plb

Package body created.
重新导出,接着报以下错误
ORA-39127: unexpected error from call to export_string :=WMSYS.LT_EXPORT_PKG.schema_info_exp('justin',0,1,'11.02.00.00.00',newblock)
ORA-04067: not executed, package body "WMSYS.LT_CTX_PKG" does not exist
ORA-06508: PL/SQL: could not find program unit being called: "WMSYS.LT_CTX_PKG"
ORA-06512: at "WMSYS.LT_EXPORT_PKG", line 1548
ORA-04067: not executed, package body "WMSYS.LT_CTX_PKG" does not exist
ORA-06508: PL/SQL: could not find program unit being called: "WMSYS.LT_CTX_PKG"
接着查找创建文件
[oracle@db admin]$ more owmctxb* | grep -i  "create or replace package body wmsys.lt_ctx_pkg wrapped"
create or replace package body wmsys.lt_ctx_pkg wrapped

SQL> @owmctxb.plb

Package body created.


Context created.
再试着导出,接着报错
ORA-39127: unexpected error from call to export_string :=WMSYS.LT_EXPORT_PKG.schema_info_exp('justin',0,1,'11.02.00.00.00',newblock)
ORA-04067: not executed, package body "WMSYS.LTUTIL" does not exist
ORA-06508: PL/SQL: could not find program unit being called: "WMSYS.LTUTIL"
ORA-06512: at "WMSYS.LT_EXPORT_PKG", line 1549

[oracle@db admin]$ more owmutlb* | grep -i  "create or replace package body wmsys.ltUtil wrapped "
create or replace package body wmsys.ltUtil wrapped

SQL> @owmutlb.plb

Package body created.
再次导入,错误没有了

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/15480802/viewspace-687499/,如需转载,请注明出处,否则将追究法律责任。

下一篇: centos下安装oracle
请登录后发表评论 登录
全部评论

注册时间:2010-03-18

  • 博文量
    375
  • 访问量
    3159485