expdp报错ora 39126
11.2.0.2,expdp报错:
ORA-39126: Worker unexpected fatal error in KUPW$WORKER.GET_TABLE_DATA_OBJECTS []
ORA-31642: the following SQL statement fails:
BEGIN "SYS"."DBMS_CUBE_EXP".SCHEMA_CALLOUT(:1,0,1,'11.02.00.00.00'); END;
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.DBMS_METADATA", line 1245
ORA-04063: package body "SYS.DBMS_CUBE_EXP" has errors
ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_CUBE_EXP"
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.KUPW$WORKER", line 8353
查询oracle文档ID 1328829.1,原因是
OLAP objects remain existing in data dictionary while OLAP is not installed or was de-installed. Verify with:
SELECT * FROM SYS.EXPPKGACT$ WHERE PACKAGE = 'DBMS_CUBE_EXP';
-- backup the table SYS.EXPPKGACT$ before deleting the row
-- delete the DBMS_CUBE_EXP from the SYS.EXPPKGACT$
SQL> COMMIT;
Run EXPDP command again.
最新文章
- 【SQL语句】update ... ... from ......
- day8-多进程和多线程
- Java表单类双击提交
- 使用==比较String类型
- Android布局---相对布局
- php 对象调用方法
- Javascript类型——boolean类型
- jQuery--Promise object
- iOS面试题02-数据存储
- [ExtJS5学习笔记]第十六节 Extjs5使用panel新增的ViewModel属性绑定数据
- RxJava 2.x 使用最佳实践
- shell实现大批量word转码然后分析相关字段
- ubuntu安装jdk8
- ubuntu 14.04安装zabbix3.0以及汉化
- 【转】Git版本控制软件从入门到精通学习手册
- POJ2689 Prime Distance(数论:素数筛选模板)
- tornado-cookies+pycket 验证
- XML文件的小结
- 由pushViewController说起可能出线的各种死法
- QuickBI助你成为分析师-数据建模(二)
热门文章
- 安装Yii框架时init.bat闪退的处理方法
- 在Linux中永久设置Anaconda环境变量的方法
- Android String操作
- Linux卷配置管理
- Python操作mysql之SQLAchemy(ORM框架)
- java变量命名规则
- WM_CLOSE WM_DESTROY WM_QUIT的区别
- ERROR 1267 (HY000): Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '='
- ziparchiver添加后编译出错
- HTML实体字符转化为HTML标签