数据泵导入问题求解，据说是Oracle11gR2的Bug？

图森 2017-09-13 06:03:31

本人菜鸟一枚，Oracle还没入门，最近有一份Oracle备份数据需要导入到本机Oracle数据库中，根据提供的相关资料，用的是数据泵IMPDP方式导入，但是遇到一个问题

网上也查了一下原因，说是Oracle的一个bug（http://bbs.cldera.com/archiver/tid-31175.html），也没找到合适的解决方法，不知道有没有人遇到过，求解答，感激不尽！

备注：下面是本人根据拿到的文件中的导出说明写的一些语句，不知道是否有错误，请各位指教

最后附上该数据的导入日志文件，供大家参考，还请各位不吝指教！

;;; 

Import: Release 11.2.0.1.0 - Production on 星期三 9月 13 17:12:24 2017



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

;;; 

连接到: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

已成功加载/卸载了主表 "SXDS"."SYS_IMPORT_FULL_16" 

启动 "SXDS"."SYS_IMPORT_FULL_16":  sxds/********@sxds directory=dumpdir dumpfile=db_dw_dump%U.dmp logfile=sxds.log remap_schema=DB_DW:sxds 

处理对象类型 SCHEMA_EXPORT/TABLE/TABLE_DATA

ORA-39126: 在 KUPW$WORKER.UPATE_TD_ROW_IMP [64] 中 Worker 发生意外致命错误

TABLE_DATA:"SXDS"."BD_DIM_TC"

ORA-31603: 对象 "BD_DIM_TC" 属于类型 TABLE, 在方案 "SXDS" 中未找到

ORA-06512: 在 "SYS.DBMS_SYS_ERROR", line 105

ORA-06512: 在 "SYS.KUPW$WORKER", line 8171

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

  object      line  object

  handle    number  name

00000004AA2B88B8     18990  package body SYS.KUPW$WORKER

00000004AA2B88B8      8192  package body SYS.KUPW$WORKER

00000004AA2B88B8     18552  package body SYS.KUPW$WORKER

00000004AA2B88B8      4105  package body SYS.KUPW$WORKER

00000004AA2B88B8      8875  package body SYS.KUPW$WORKER

00000004AA2B88B8      1649  package body SYS.KUPW$WORKER

0000000485C40DD8         2  anonymous block

ORA-39126: 在 KUPW$WORKER.UPATE_TD_ROW_IMP [64] 中 Worker 发生意外致命错误

TABLE_DATA:"SXDS"."BD_DIM_TC"

ORA-31603: 对象 "BD_DIM_TC" 属于类型 TABLE, 在方案 "SXDS" 中未找到

ORA-06512: 在 "SYS.DBMS_SYS_ERROR", line 105

ORA-06512: 在 "SYS.KUPW$WORKER", line 8171

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

  object      line  object

  handle    number  name

00000004AA2B88B8     18990  package body SYS.KUPW$WORKER

00000004AA2B88B8      8192  package body SYS.KUPW$WORKER

00000004AA2B88B8     18552  package body SYS.KUPW$WORKER

00000004AA2B88B8      4105  package body SYS.KUPW$WORKER

00000004AA2B88B8      8875  package body SYS.KUPW$WORKER

00000004AA2B88B8      1649  package body SYS.KUPW$WORKER

0000000485C40DD8         2  anonymous block

作业 "SXDS"."SYS_IMPORT_FULL_16" 因致命错误于 17:12:32 停止

下面是该数据导出日志部分信息，供大家参考

;;; 

Export: Release 11.2.0.4.0 - Production on Fri Sep 1 19:23:02 2017



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 "DB_DW"."SYS_EXPORT_SCHEMA_04":  DB_DW/******** directory=DIR_DB logfile=db_dw_dmp.log dumpfile=db_dw_dump%U.dmp filesize=200G

Estimate in progress using BLOCKS method...

Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA

Total estimation using BLOCKS method: 892.4 GB

. . exported "DB_DW"."ZH_ZM_SRNSMX_TEMP"                 37.29 GB 169462422 rows

. . exported "DB_DW"."ZH_CW_ZCFZB_XQYKJZZ_JS"            16.74 GB 166585890 rows

. . exported "DB_DW"."ZH_SB_CWBB_XQYKJZZ_ZCFZB"          16.76 GB 94387219 rows

. . exported "DB_DW"."ZH_SB_KJGRSDSBGB_MX_TEMP"          16.36 GB 82223769 rows

. . exported "DB_DW"."ZH_DJ_GSNSRSRNSXX2"                14.75 GB 63151613 rows

. . exported "DB_DW"."ZH_SB_CWBB_XQYKJZZ_LRB"            13.01 GB 80729600 rows

. . exported "DB_DW"."ZH_ZM_SSWSZMJLMX_TEMP"             12.08 GB 67915344 rows

. . exported "DB_DW"."ZH_CW_LRB_XQYKJZZ_JS"              11.10 GB 100243968 rows

. . exported "DB_DW"."ZH_DJ_NSRXX_ZH"                    10.64 GB 62384034 rows

. . exported "DB_DW"."ZH_SB_CWBB_XQYKJZZ_XJLLB"          9.630 GB 54952370 rows

. . exported "DB_DW"."ZH_CW_ZCFZB_QYKJZD_JS"             9.205 GB 90448896 rows

. . exported "DB_DW"."ZH_DJ_BLXTTBSBRZXX"                8.439 GB 9748451 rows

. . exported "DB_DW"."ZH_SB_KJGRSDSBGB_MX_NEU"           8.585 GB 42021804 rows

. . exported "DB_DW"."JS_SY_NSRFSZRKXX"                  7.995 GB 161909999 rows

. . exported "DB_DW"."ZH_SB_ZSXX"                        7.828 GB 25378295 rows

. . exported "DB_DW"."ZH_SB_SBXX_OLD"                    7.434 GB 46196440 rows