oracle11.2.0.3.0 - 64bit,数据泵导入报ORA-06502，解决

最新推荐文章于 2021-04-13 16:44:28 发布

xLevi

最新推荐文章于 2021-04-13 16:44:28 发布

阅读量1.5k

点赞数

本文链接：https://blog.csdn.net/u010724179/article/details/13874419

版权

在使用Oracle 11.2.0.3.0进行数据泵导入时遇到ORA-06502错误。问题出在REMAP_TABLE参数设置上，原本包含属主的设置导致了错误。通过去掉属主，即修改为REMAP_TABLE=BD_ALL_NOMUSICSPBIZIINFO:BD_ALL_NOMUSICSPBIZIINFO_BAK1，成功解决了导入问题。

摘要由CSDN通过智能技术生成

数据泵导入是报ORA-06502错误，

信息如下：

oracle> impdp parfile=impp.par

Import: Release 11.2.0.3.0 - Production on Thu Oct 31 20:54:07 2013

Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options

Job: CONMETAMMO1
Operation: IMPORT
Mode: FULL
State: EXECUTING
Bytes Processed: 0
Current Parallelism: 1
Job Error Count: 0
Dump File: /oracle/work/peng.dmp

Worker 1 Status:
Process Name: DW00
State: EXECUTING

Worker 2 Status:
State: UNDEFINED
Master table "CONME"."CONMETAMMO1" successfully loaded/unloaded

Job: CONMETAMMO1
Operation: IMPORT
Mode: FULL
State: EXECUTING
Bytes Processed: 0
Current Parallelism: 1
Job Error Count: 0
Dump File: /oracle/work/peng.dmp

Worker 1 Status:
Process Name: DW00
State: EXECUTING

Worker 2 Status:
State: UNDEFINED
Starting "CONME"."CONMETAMMO1": common/******** parfile=imppeng.par

Job: CONMETAMMO1
Operation: IMPORT
Mode: FULL
State: EXECUTING
Bytes