暂无图片
分享
杨杰
2019-06-14
oracle 11.2.0.4 expdp 报错

麻烦老师们帮忙指导下,非常感谢!


环境 :redhat6.4 x86_64 + oracle11.2.0.4.0

导出命令:expdp user/passwd directory=bak dumpfile=111.dmp logfile=111.log content=metadata_only exclude=statistics

报错日志:

Export: Release 11.2.0.4.0 - Production on Thu Jun 13 09:50:38 2019


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, Automatic Storage Management, OLAP, Data Mining

and Real Application Testing options

Starting "NOAP"."SYS_EXPORT_SCHEMA_01":  user/******** DIRECTORY=bak CONTENT=METADATA_ONLY DUMPFILE=111.dmp logfile=111.log exclude=STATISTICS

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

Processing object type SCHEMA_EXPORT/PASSWORD_HISTORY

Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA

Processing object type SCHEMA_EXPORT/SEQUENCE/SEQUENCE

Processing object type SCHEMA_EXPORT/TABLE/TABLE

ORA-39126: Worker unexpected fatal error in KUPW$WORKER.FETCH_XML_OBJECTS [TABLE:"USER"."TABLE_TEST"]

ORA-06531: Reference to uninitialized collection

ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95

ORA-06512: at "SYS.KUPW$WORKER", line 9715

----- PL/SQL Call Stack -----

  object      line  object

  handle    number  name

0x104c9d6f60     21979  package body SYS.KUPW$WORKER

0x104c9d6f60      9742  package body SYS.KUPW$WORKER

0x104c9d6f60     11838  package body SYS.KUPW$WORKER

0x104c9d6f60      2808  package body SYS.KUPW$WORKER

0x104c9d6f60     10422  package body SYS.KUPW$WORKER

0x104c9d6f60      1824  package body SYS.KUPW$WORKER

0x104eb5af50         2  anonymous block

Job "NOAP"."SYS_EXPORT_SCHEMA_01" stopped due to fatal error at Fri Jun 14 01:09:42 2019 elapsed 0 15:18:43


收藏
分享
3条回答
默认
最新
Moone

可能是一个Schema-level DataPump Export (EXPDP) With CONTENT=METADATA_ONLY Fails With Errors ORA-39126 ORA-1403 (文档 ID 1469407.1)的bug

1、CONTENT=ALL

2、导出的文件可以通过如下impdp提取sqlfile

impdp <LOGIN>/<PASSWORD> directory=<DIRECTORY_NAME> dumpfile=<DUMP_NAME>.dmp SQLFILE=<SQL_FILE_NAME>>.sql FULL=Y

暂无图片 评论
暂无图片 有用 0
杨杰

好的,我试试,谢谢老师指导

暂无图片 评论
暂无图片 有用 0
杨杰
问题已关闭: 问题已经得到解决
暂无图片 评论
暂无图片 有用 0
回答交流
提交
问题信息
请登录之后查看
邀请回答
暂无人订阅该标签,敬请期待~~
暂无图片墨值悬赏