expdp时候遇到ORA-04067

做一次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/，如需转载，请注明出处，否则将追究法律责任。