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

最新推荐文章于 2025-04-11 17:13:18 发布

原创最新推荐文章于 2025-04-11 17:13:18 发布 · 3k 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#ORA-39127

Oracle Trouble Shooting 专栏收录该内容

10 篇文章

订阅专栏

本文记录了一次使用Oracle数据泵导出数据时遇到的ORA-39127和ORA-44002错误，并给出了详细的解决步骤。通过调整EXPPKGACT$表中的LT_EXPORT_PKG包信息，成功解决了导出问题。

最近导个数据泵都接连遇到一些奇怪的错误，这次导数据又遇到了。错误如下

[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 这个的数据

然后重新导出就成功了。