最新文章专题视频专题问答1问答10问答100问答1000问答2000关键字专题1关键字专题50关键字专题500关键字专题1500TAG最新视频文章推荐1 推荐3 推荐5 推荐7 推荐9 推荐11 推荐13 推荐15 推荐17 推荐19 推荐21 推荐23 推荐25 推荐27 推荐29 推荐31 推荐33 推荐35 推荐37视频文章20视频文章30视频文章40视频文章50视频文章60 视频文章70视频文章80视频文章90视频文章100视频文章120视频文章140 视频2关键字专题关键字专题tag2tag3文章专题文章专题2文章索引1文章索引2文章索引3文章索引4文章索引5123456789101112131415文章专题3
当前位置: 首页 - 科技 - 知识百科 - 正文

expdp错误ORA-39029

来源:动视网 责编:小采 时间:2020-11-09 11:29:08
文档

expdp错误ORA-39029

expdp错误ORA-39029:源端hp-unix+oracle10g-r204-rac,目标端redhat+oracle10g。expdp错误ORA-39029 源端hp-unix+Oracle10g-r204-rac,目标端RedHat+oracle10g。在目标端使用network_link导出,报错如下:rm /opt/oradir/expdp.dmpexp
推荐度:
导读expdp错误ORA-39029:源端hp-unix+oracle10g-r204-rac,目标端redhat+oracle10g。expdp错误ORA-39029 源端hp-unix+Oracle10g-r204-rac,目标端RedHat+oracle10g。在目标端使用network_link导出,报错如下:rm /opt/oradir/expdp.dmpexp


源端hp-unix+oracle10g-r204-rac,目标端redhat+oracle10g。expdp错误ORA-39029

源端hp-unix+Oracle10g-r204-rac,目标端RedHat+oracle10g。
在目标端使用network_link导出,报错如下:
rm /opt/oradir/expdp.dmp
expdp \"sys/oracle as sysdba\" directory=oradir network_link=portal95 schemas=rbt dumpfile=expdp.dmp logfile=expdp.log exclude=statistic

ORA-39014: One or more workers have prematurely exited.
ORA-39029: worker 2 with process name "DW02" prematurely terminated
ORA-31671: Worker process DW02 had an unhandled exception.
ORA-12801: error signaled in parallel query server
ORA-29913: error in executing ODCIEXTTABLEPOPULATE callout
ORA-29400: data cartridge error
KUP-04038: internal error: kupax-meta1
ORA-06512: at "SYS.ORACLE_DATAPUMP", line 78
ORA-06512: at "SYS.KUPW$WORKER", line 1345
ORA-06512: at line 2

Job "SYS"."SYS_EXPORT_SCHEMA_05" stopped due to fatal error at 13:53:52

alert.log
首先看到的错误是:
Thu May 24 13:51:34 2012
The value (30) of MAXTRANS parameter ignored.
kupprdp: master process DM00 started with pid=38, OS id=5089
to execute - SYS.KUPM$MCP.MAIN('SYS_EXPORT_SCHEMA_05', 'SYS', 'KUPC$C_1_20120524135135', 'KUPC$S_1_20120524135135', 0);
kupprdp: worker process DW01 started with worker id=1, pid=39, OS id=5091
to execute - SYS.KUPW$WORKER.MAIN('SYS_EXPORT_SCHEMA_05', 'SYS');
kupprdp: worker process DW02 started with worker id=2, pid=40, OS id=5096
to execute - SYS.KUPW$WORKER.MAIN('SYS_EXPORT_SCHEMA_05', 'SYS');
kupprdp: worker process DW03 started with worker id=3, pid=42, OS id=5098
to execute - SYS.KUPW$WORKER.MAIN('SYS_EXPORT_SCHEMA_05', 'SYS');
kupprdp: worker process DW04 started with worker id=4, pid=43, OS id=5100
to execute - SYS.KUPW$WORKER.MAIN('SYS_EXPORT_SCHEMA_05', 'SYS');
kupprdp: worker process DW05 started with worker id=5, pid=44, OS id=5102
to execute - SYS.KUPW$WORKER.MAIN('SYS_EXPORT_SCHEMA_05', 'SYS');
kupprdp: worker process DW06 started with worker id=6, pid=45, OS id=5104
to execute - SYS.KUPW$WORKER.MAIN('SYS_EXPORT_SCHEMA_05', 'SYS');
kupprdp: worker process DW07 started with worker id=7, pid=46, OS id=5106
to execute - SYS.KUPW$WORKER.MAIN('SYS_EXPORT_SCHEMA_05', 'SYS');
kupprdp: worker process DW08 started with worker id=8, pid=47, OS id=5108
to execute - SYS.KUPW$WORKER.MAIN('SYS_EXPORT_SCHEMA_05', 'SYS');
Thu May 24 13:52:15 2012

经查,该错误是备份时创建备份主表(Master Table)产生的(使用类似CREATE TABLE () INITRANS 10 MAXTRANS 30语句创建),提示参数MAXTRANS已经被废弃而已,是个bug,,略过。
继续往下看:
Memory Notification: Library Cache Object loaded into SGA
Heap size 2048K exceeds notification threshold (2048K)
KGL object name :SYS.KUPC$C_1_20120524135135

文档

expdp错误ORA-39029

expdp错误ORA-39029:源端hp-unix+oracle10g-r204-rac,目标端redhat+oracle10g。expdp错误ORA-39029 源端hp-unix+Oracle10g-r204-rac,目标端RedHat+oracle10g。在目标端使用network_link导出,报错如下:rm /opt/oradir/expdp.dmpexp
推荐度:
标签: 数据 错误 error
  • 热门焦点

最新推荐

猜你喜欢

热门推荐

专题
Top