欢迎光临
感受代码之美

oracle导入数据impdp报错ORA-29913及ORA-31693问题解决

执行导入命令,报错信息如下:

impdp "sdjw_ww_query/sdjw_ww_query@ora11g" attach=SYS_IMPORT_FULL_01


Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
Master table "SDJW_WW_QUERY"."SYS_IMPORT_FULL_02" successfully loaded/unloaded
Starting "SDJW_WW_QUERY"."SYS_IMPORT_FULL_02":  sdjw_ww_query/********@ora11g directory=temp_dir dumpfile=waiwang_init_%U.dmp parallel=8 table_exists_action=REPLACE data_options=skip_constraint_errors logfile=neiwang_import.log remap_schema=ww_iarp:sdjw_ww_query REMAP_TABLESPACE=JW_TABLESPACE:JW_TABLESPACE 
Processing object type TABLE_EXPORT/TABLE/TABLE
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
. . imported "SDJW_WW_QUERY"."JW_QYDJ_CZXX_ZS_INIT"      2.276 GB 12970739 rows
. . imported "SDJW_WW_QUERY"."JW_NB_QY_JBXX_MAIN_INIT"   2.848 GB 7573572 rows
. . imported "SDJW_WW_QUERY"."JW_QYDJ_JBXX_ZS_INIT"      2.555 GB 4373304 rows
ORA-31693: Table data object "SDJW_WW_QUERY"."JW_NB_GT_ZCZK_MAIN_INIT" failed to load/unload and is being skipped due to error:
ORA-29913: error in executing ODCIEXTTABLEOPEN callout
ORA-31693: Table data object "SDJW_WW_QUERY"."JW_GTDJ_JYZXX_ZS_INIT" failed to load/unload and is being skipped due to error:
ORA-29913: error in executing ODCIEXTTABLEOPEN callout
. . imported "SDJW_WW_QUERY"."JW_QYDJ_CWFZR_ZS_INIT"     263.4 MB 1738417 rows
. . imported "SDJW_WW_QUERY"."JW_QYDJ_LLR_ZS_INIT"       416.0 MB 2697933 rows
. . imported "SDJW_WW_QUERY"."JW_GTDJ_DXXX_ZS_INIT"      209.1 MB  932003 rows
. . imported "SDJW_WW_QUERY"."JW_GTDJ_ZXXX_ZS_INIT"      496.2 MB 3830080 rows
. . imported "SDJW_WW_QUERY"."JW_GTDJ_JBXX_ZS_INIT"      4.651 GB 10772051 rows
. . imported "SDJW_WW_QUERY"."JW_QYDJ_BGSX_LS_INIT"      6.224 GB 15972582 rows
. . imported "SDJW_WW_QUERY"."JW_NB_GT_JBXX_MAIN_INIT"   5.742 GB 21331067 rows
. . imported "SDJW_WW_QUERY"."JW_NB_HZS_JBXX_MAIN_INIT"  205.6 MB  648522 rows
. . imported "SDJW_WW_QUERY"."JW_QYDJ_DXXX_ZS_INIT"      142.5 MB  631955 rows
. . imported "SDJW_WW_QUERY"."JW_QYDJ_ZXXX_ZS_INIT"      147.2 MB 1018155 rows
. . imported "SDJW_WW_QUERY"."JW_E_LI_ILLDISHONESTY_INIT"  11.43 MB   48910 rows
. . imported "SDJW_WW_QUERY"."JW_QYDJ_FZJG_ZS_INIT"      39.39 MB  269466 rows
. . imported "SDJW_WW_QUERY"."JW_NB_HZS_ZCZK_MAIN_INIT"  80.17 MB  651980 rows
. . imported "SDJW_WW_QUERY"."JW_QYDJ_RYXX_ZS_INIT"      1.062 GB 7820202 rows

解决方式,将并行参数parallel去掉,即将下面命令:

impdp sdjw_ww_query/sdjw_ww_query@ora11g directory=temp_dir dumpfile=waiwang_init_%U.dmp parallel=8 table_exists_action=REPLACE data_options=skip_constraint_errors logfile=neiwang_import.log remap_schema=ww_iarp:sdjw_ww_query REMAP_TABLESPACE=JW_TABLESPACE:JW_TABLESPACE;

改为:

impdp sdjw_ww_query/sdjw_ww_query@ora11g directory=temp_dir dumpfile=waiwang_init_%U.dmp table_exists_action=REPLACE data_options=skip_constraint_errors logfile=neiwang_import.log remap_schema=ww_iarp:sdjw_ww_query REMAP_TABLESPACE=JW_TABLESPACE:JW_TABLESPACE;

参考:

  1. ORA-31693错误
赞(4)
未经允许禁止转载:四个空格 » oracle导入数据impdp报错ORA-29913及ORA-31693问题解决

评论 抢沙发

  • 昵称 (必填)
  • 邮箱 (必填)
  • 网址