ORA-39127: unexpected error from call to "WMSYS"."LT_EXPORT_PKG"."SCHEMA_INFO_EXP"

版权声明:本文为博主原创文章,未经博主允许不得转载。 https://blog.csdn.net/zhengwei125/article/details/53894255
最近导个数据泵都接连遇到一些奇怪的错误,这次导数据又遇到了。错误如下


[oracle@oracle dump]$ expdp system/oracle directory=d1 dumpfile=test1.dmp schemas=test1
Export: Release 11.2.0.4.0 - Production on Tue Dec 27 10:55:34 2016
Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Starting "SYSTEM"."SYS_EXPORT_SCHEMA_01":  system/******** directory=d1 dumpfile=test1.dmp schemas=test1 
Estimate in progress using BLOCKS method...
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 25.87 MB
Processing object type SCHEMA_EXPORT/USER
Processing object type SCHEMA_EXPORT/SYSTEM_GRANT
Processing object type SCHEMA_EXPORT/ROLE_GRANT
Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
ORA-39127: unexpected error from call to "WMSYS"."LT_EXPORT_PKG"."SCHEMA_INFO_EXP" 
ORA-44002: invalid object name
ORA-06512: at "SYS.DBMS_ASSERT", line 383
ORA-06512: at "SYS.DBMS_METADATA", line 10239
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/SEQUENCE/SEQUENCE
Processing object type SCHEMA_EXPORT/TABLE/TABLE
Processing object type SCHEMA_EXPORT/TABLE/COMMENT
Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type SCHEMA_EXPORT/VIEW/VIEW
Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
ORA-39127: unexpected error from call to "WMSYS"."LT_EXPORT_PKG"."SCHEMA_INFO_EXP" 
ORA-44002: invalid object name
ORA-06512: at "SYS.DBMS_ASSERT", line 383


经检查METALINK,发现一篇文档非常有帮助:

How To Resolve Common EXP And EXPDP Issues Related to LT_EXPORT_PKG? [ID 1275486.1]


根据该文进行检查:

 LT_EXPORT_PKG在10.2.0.4之前,应该在SYS模式下,但在10.2.0.4及之后,该包已经移到WMSYS模式下.


1. 检查EXPPKGACT$表内容

SQL> select *  from  sys.exppkgact$ where package='LT_EXPORT_PKG'; 

PACKAGE       SCHEMA  CLASS           LEVEL#
------------------------------ ----------------  
LT_EXPORT_PKG   WMSYS     1             1000
LT_EXPORT_PKG   WMSYS     2             1000


按理在10.2.0.4以上的版本, LT_EXPORT_PKG包在wmsys模式下,上面的查询中,只有两行

解决方法:
create table sys.exppkgact$_backup as select * from sys.exppkgact$;  --备份表
delete from sys.exppkgact$ where package ='LT_EXPORT_PKG';           --删除了表里值为 LT_EXPORT_PKG 这个的数据


然后重新导出就成功了。





展开阅读全文

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