ORA-39127: unexpected error from call to "WMSYS"."LT_EXPORT_PKG"."SCHEMA_INFO_EXP"
来源:互联网 发布:w3c php手册下载 编辑:程序博客网 时间:2024/05/17 17:44
最近导个数据泵都接连遇到一些奇怪的错误,这次导数据又遇到了。错误如下
[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 这个的数据
然后重新导出就成功了。
[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 这个的数据
然后重新导出就成功了。
0 0
- ORA-39127: unexpected error from call to "WMSYS"."LT_EXPORT_PKG"."SCHEMA_INFO_EXP"
- ORA-04063: package body "WMSYS.LT_EXPORT_PKG" has errors
- exp ORA-04063 SYS.LT_EXPORT_PKG
- Fatal error: Call to private MyObject::__construct() from invalid context
- ie video play Error: Unexpected call to method or property access
- How to resolve ORA-19706 error when select from dblink
- expdp报错:ora-39127“WMSYS”
- Unexpected call to method or property access
- Error armlink L6238 Startup.o(Start) contains invalid call from '~PRES8' function to 'REQ8' functio
- ORA:WMSYS.WM_CONCAT函数
- ORA-12012: error on auto execute of job;PLS-00306: wrong number or types ofarguments in call to
- How to call function from register view
- How to call Postback from Javascript
- How to call javascript from Android?
- 首遇ORA-00600: internal error code, arguments: [evapth : unexpected evaluation], [], [], [], [], [], [
- eclipse链接hadoop2.5.1时报错Error:Call From roo/10.30.12.xxx to hostname1:9000 failed on connection excep
- Unexpected 500 Internal Server Error from Bookie Rest Service
- Fatal error: Call to undefined function mysql_connect()
- MySQL大表优化方案
- iOS的Cocoa 及NS框架
- 数据库协作运维大势所趋
- php数据库操作-创建库和表以及插入数据
- 重定向 和 转发 的问题
- ORA-39127: unexpected error from call to "WMSYS"."LT_EXPORT_PKG"."SCHEMA_INFO_EXP"
- 第7章 sed、gawk介绍与正则表达式-----------(sed编辑器简单使用)
- Hadoop到底是什么?
- Leetcode 333. Largest BST Subtree (Medium) (cpp)
- 10分钟教会你Mac上搭建Web服务器
- Spring学习之旅(八) Spring Security的使用
- java中设计模式-Strategy(策略模式)
- 个别操作需要有相应的声音提醒,
- Linux 下安装PHP+Apache+Mysql 手记