oracle 31693,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
魔乐社区(Modelers.cn) 是一个中立、公益的人工智能社区,提供人工智能工具、模型、数据的托管、展示与应用协同服务,为人工智能开发及爱好者搭建开放的学习交流平台。社区通过理事会方式运作,由全产业链共同建设、共同运营、共同享有,推动国产AI生态繁荣发展。
更多推荐


所有评论(0)